Very Computer

Has anyone come up with a way of providing source
control, say with Source Safe, for all of the Stored
Procs, Functions, and Triggers that an application will
use?

I can do this externally, but if I use the .NET IDE,
wouldn't it be nice if all of the scripts were checked in
and out through Source Safe?

Quote:> I can do this externally, but if I use the .NET IDE,
> wouldn't it be nice if all of the scripts were checked in
> and out through Source Safe?

Yeh... You right. It will be nve to do this.

Hi Bob,

You can use VSS to keep your stored procedure under safe control. To make
this,
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
control"
on the tools=>options=>database tools tab. The option is "Enable version
control"

4) Install VSS on server machine

5) Make sure SQL is running as a domain account and that that account has
been
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
sure
to use NT authentication.

8) Right click on the stored procedure node and select add to Source
Control,
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
SP's
allowing you to right click and add to Source Control

Sincerely,

Alvin Zhao
Microsoft Support Engineer

This posting is provided "AS IS" with no warranties, and confers no rights.