Posts
Sort by recent activity
"EXEC : warning : Ignored statement found in file" warnings
SQL Source Control is adding "USE [DATABASE_NAME]" statements to a handful of our Stored Procedures and I'm not sure why. When we deploy database changes, we see the warning
EXEC : warning : Ignor...
Git, Linked Tables, and Branching/Merging
We've migrated most of our SVN repos to Git and developers are working mostly with feature branches that get merged into a develop branch (using the GitFlow branch development structure).http://nvi...
Preferred Method of Disabling SQLCop Tests
There are a few SQLCop tests that aren't relevant to our local or test environments.
What is the preferred method for disabling these SQLCop tests? Just delete them? Add a RETURN statement in the...
tSQLt.AssertNotEquals and tSQLt.AssertLike Missing?
I installed the tSQLt objects using SQL Test and I can't find AssertNotEquals or AssertLike anywhere. Is this a known issue? I have the latest SQL Test installed (1.5.0.85), but I created the tSQ...
This serial number has been disabled
I'm seeing the following error message in SQL Source Control:
I just got this machine and I deactivated my license from my old machine. I'm not sure why I am seeing this error.
SQL Prompt version 5
I upgraded to version 6 without realizing that my current license is only good for SQL Prompt version 5.
Where can I download SQL Prompt version 5.x?
Why do inserted/updated records get moved to the top?
I'm sure this has been asked before, but the search function on phpBB is quite horrible.
When you add or update records, the underlying script puts those records at the top of the generated file in...
Filter SQL Test objects via command line or XML config
Is there an easy way to filter out objects needed for SQL Test / tSQLt / SQLCop? I thought there was an option to have these automatically filtered in SQL Compare.
Right now, I am filtering these ...
Automatically change CREATE statement to ALTER
It would be nice if SQL Prompt could automatically change a CREATE statement to an ALTER statement once the CREATE statement has been executed. This would apply to stored procs, views, functions a...
AddDatabaseUseStatement option?
Is there a way to force the inclusion of the USE [DATABASENAME] statement in the generated script? This exists for SQL Compare (AddDatabaseUseStatement) and would be handy in SQL Data Compare to e...