Can anyone explain how to use the VSS integration in SSMS to mange stored
procedures?  We use VSS to manage source code in Visual Studio but I can't 
figure out how this is done with stored procedures in SMSS

Do please check the "Source Control Services" topics in Books OnLine, "SQL
Server 2005 Tools and Utilities Reference Overview" part.

What I do is:

1) Create a Solution for stored procedures.
2) Add the solution to Source Control
3) Add a new query.
4) Select a stored procedure
5) Script the SP as CREATE to clipboard
6) Paste into the new query
7) Add extra code at the bottom to grant permissions
8) Rename NewQuery.sql to my_SP.sql in the solution explorer
9) Check in pending check ins
10) repeat steps 3 to 9 until you have all your SP's under Source Control

I always script an existing sp as create so that I can't accidentally hit F5
You can do things like add a separate project to the solution for each
database or a separate solution for each database or any other way that
suits your way of organising things.

Regards,
Nigel Ainscoe MBCS MCP



Show quoteHide quote

lost sa password due to loss of employee
Backup using the proxy account in SQL2005
BCP genric error
Problem on scripting stored procedures
Telling if SQL2005 is running