tsqlt Questions
4
Solved
I recently installed SQL Server 2017 Express and localdb (general availablity). While attempting to install the tSQLt framework I've discovered a new security feature implemented in SQL Server 2017...
Roadability asked 3/10, 2017 at 18:29
5
faketable function did not reassign to normal. All my tables I used faketable on now contain the content of the values I used in the insert of the unit test. It was many tables and it has left my d...
Ferromagnetic asked 28/8, 2012 at 14:8
5
Solved
When I try to install tSQLt onto an existing database i get the following error:
The database owner SID recorded in the master database differs from
the database owner SID recorded in database ...
Crumhorn asked 12/9, 2012 at 13:45
1
I'm trying to do some improvements for tSQLt framework and I'm mostly finish, but can't do that as few tests related to the certificate I wasn't touching are still failing:
[exec] |18|[InstallExt...
Perpetua asked 29/10, 2019 at 7:9
1
Solved
I am trying to run tSQLt solution locally by following instructions in the tSQLt\Build\Install the tSQLt build.docx.
Re-built tSQLtCLR solution:
1>------ Rebuild All started: Project: tSQLtCLR...
Olson asked 10/8, 2019 at 9:1
4
Solved
exec tSQLt.SetFakeViewOn 'dbo.viewWithIssues';
GO
CREATE PROCEDURE TestChanges.[Test Data]
AS
BEGIN
...
exec tSQLt.FakeTable 'dbo.viewWithIssues', @identity=1, @ComputedColumns=1, @Defaults=1;
INS...
3
Solved
I have a new project that needs SQL Server unit test, and CI/CD with VSTS.
Below is the features that are required
SQL server unit test against stored procedure, initial target tables setup for ...
Correa asked 17/12, 2017 at 22:21
4
Solved
I have a stored procedure that uses the GETUTCDATE() function several times. It's a very specific line of business sproc, so it probably wouldn't make a lot of sense to show it here. Having said th...
Halftimbered asked 10/4, 2014 at 18:23
3
Solved
The tSQLt test framework requires to set TRUSTWORTHY ON for the database, and to enable SQL CLR for the server.
Why are these required? Is it possible to achieve the same/similar functionality wit...
Dioptrics asked 10/5, 2012 at 8:29
4
Solved
I'm developing a database using the Red Gate SQL Developer tools. SQL Test, the SSMS add-in that runs tSQLt tests, lacks a way to rename test classes.
I have a test called [BackendLayerCustomerAdm...
4
I recently was calling a procedure that contained a rasierror in the code. The raiserror was in a try catch block. Also a BEGIN TRAN was in the same try catch block after the raiserror. The Catch b...
Forever asked 23/1, 2012 at 14:26
3
Solved
I really like tsqlt to test procs and functions, but really would like to be able to also execute SSIS packages and take advantage of FakeTable and AssertEquals to determine if it was the SSIS pack...
Hindermost asked 3/7, 2013 at 12:28
1
Solved
Is it possible to ignore certain columns that are almost definitely going to be different in a tSQLt AssertEqualsTable? Examples would be primary keys from the two results tables, insert/update dat...
Youngran asked 23/7, 2014 at 9:46
2
Solved
I have started using tsqlt, and my question is it possible to have a separate database with just the testing stuff? (tables/sp's/assemblies etc).
This testing database will sit on the same instanc...
2
Solved
The Redgate tool SQLTest for SQL unit testing now offers the ability to add tests from SQLCop however the Redgate tool only comes with few of those tests prebuild.
Since tests are just stored pro...
Mapp asked 27/3, 2012 at 22:52
2
Solved
I’ve been writing some tSQLt database unit tests (via Red Gate SQL Test) on procedures which call tables containing (persisted) computed columns recently, and note that if I use the FakeTable SP, I...
Cirrhosis asked 23/2, 2012 at 15:15
1
© 2022 - 2024 — McMap. All rights reserved.