You can use VSS to keep your stored procedure under safe control. To make
you can follow the steps below.
1) Install VS.Net on client machine
2) Install VSS on client machine
3) Open the VS.Net IDE and make sure that they have enabled "version
on the tools=>options=>database tools tab. The option is "Enable version
4) Install VSS on server machine
5) Make sure SQL is running as a domain account and that that account has
added to the VSS database on the server
6) Run the VS.Net install on the server machine, deselecting everything but
"Server components/VS 6 Stored Procedure Version Control"
7) Open the VS.Net IDE and create a connection to that SQL database making
to use NT authentication.
8) Right click on the stored procedure node and select add to Source
This creates the initial project structure in VSS
9) You must now still add the individual SP's. You can click on the top one,
hold down shift, and click on the last one. This will highlight all the
allowing you to right click and add to Source Control
Microsoft Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.