How to link existing Stored Proc to an existing source file in SQL Source Control and TFS?
I've an existing stored procedure and I made a minor modification on it using SSMS. I've hit an issue when checking-in due to policies. So instead of checking-in from SQL Source Control, I checked-out from the file from TFS using Visual Studio and directly modify the file and checked-in. The check-in was successful. But when I modify the stored procedure from SSMS and checkin again using SQL Source Control (with #ignorepolicies in the comment section this time), the change type is New and it created a new file. This is just example to illustrate the file being created (ExampleStoredProcName1.sql). There was a new file created with "1" suffix on it.
0 · Share on Twitter