Questions tagged [tsqlt]

An open source database unit testing framework for SQL Server.

Filter by
Sorted by
Tagged with
0
votes
1answer
112 views

Copy last modified files from network path into SQL server box and rename them using Agent job

I have to copy latest backup from a network path and bring that to my SQL server physical drive for restore, I have to do that using agent job. This is what i am doing. Created a SQL server agent ...
1
vote
1answer
53 views

Compatibility level of databases based on sql server version

We need to check for databases that are not in the correct compatibility level on a particular instance. For example, on a SQL Server 2016 instance, if there are databases that are not in ...
0
votes
1answer
62 views

TSQL SELECT statement to list a column calculated based on the value of a field

I have a table named Table1, with three fields Project ID, EmployeeID, Starting Date. Need a select statement to list all columns of the table, and an additional column to show the number of project ...
0
votes
0answers
415 views

SQL Server Agent - remotely starting jobs from machine outside AWS fails with Semaphore Timeout

Starting the same job using SSMS on the machine directly always works. Can't figure out why. Is there some firewall rule I need to allow? It works via SSMS when logged into the box directly. It does ...
6
votes
2answers
523 views

Why would I get PREEMPTIVE_OS_AUTHORIZATIONOPS using tSQLt when Working at Home?

I have an SSDT project containing tSQLt unit tests. I always find when working at home that publishing this and running all tests (from a post deploy script) is problematic (against both localdb and ...