Posts
Sort by recent activity
Bug: Fillfactor on Table Types
My Source Control crashed a few days ago and I had to reinstall it. After reinstalling (v3.6.6.178), Source Control now shows a Fillfactor setting on my user-defined Table Types, which it did not d...
SQL Test is over a year behind tSQLt
tSQLt is now on version 1.0.4941.23369 (released July 2013), but SQL Test v1.0.15.1 is still on tSQLt v1.0.4504.21220 (released May 2012). That is 2-3 versions behind. There are features tSQLt rele...
Bug: Deploy script does not include extended properites
I am changing the definition of 3 indexes. They all have extended properties for MS_Description. When SQL Compare (10.3.8.406) builds the deployment script, it drops, then creates the indexes. That...
Lost migration script in SSMS
I recently created a migration script to cover some changes to a table and sprocs. When I committed the changes yesterday, the file disappeared from the "Migrations" tab of SQL Source Control. I ha...
Trouble testing an expected sproc failure
I am new to SQL Test and I'm trying to test that a sproc will fail when expected and am having some problems. I am curious if anyone has a work-around or can tell me what I've done wrong.
From wha...
How to test a trigger?
TableA has Trigger1 that inserts data into TableB. I'd like to test that the trigger works correctly. Can I do that with SQL Test? I haven't been able to find a way yet. Does FakeTable handle trigg...
Migration script not detected
I set up my first migration script in SQL Source Control, but need some help determining why SQL Compare won't detect the script. Thank you in advance for any advice you can provide.
SQL Compare ve...
Auto-linking database to source control - make it stop.
I am using SQL Source Control v2.0.10.11 and my source control system is TFS.
I have a database called [MyDB] on server [ServDev]. I linked [MyDB] to source control. After deploying [MyDB] to [Serv...
"Get Latest" problems - must unlink/relink database
I am using SQL Source Control v2.0.10.11 and my source control system is TFS.
I have a database called [MyDB] on servers [ServDev] and [ServTest]. [ServDev] is the 1st phase of development and [Ser...
Database Roles
It would be nice to be able to enter descriptions of database roles. Roles allow extended properties (at least in SQL 2008) so it seems SQL Doc should allow that. It would be really helpful for us.