Fabrice's weblog

Tools and Source

News


Read sample chapters or buy LINQ in Action now!
Our LINQ book is also available on AMAZON

.NET jobs

Emplois .NET

The views expressed on this weblog are mine alone and do not necessarily reflect the views of my employer. The content of this weblog is independent from Microsoft or any other company. transatlantys hot news

Contact

Me

Others

Selected content

Stored procedures versioning with SQL Server and Visual SourceSafe

Here is a quick summary of the steps to add Stored Procedures to the .NET IDE:

  1. Install VS.NET on client machine
  2. Install VSS on client machine
  3. Open the VS.NET IDE and make sure to enable "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
  8. Right click on the "stored procedureS" 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

I do not remember where I found this information, but more information can be found on MSDN.

Update: Thanks to Dominic Fenton, here is an official Microsoft reference document on this subject: HOW TO: Add SQL Server 2000 Stored Procedures to Visual SourceSafe by Using Visual Studio .NET

Posted: Feb 24 2003, 06:37 PM by Fabrice Marguerie | with 16 comment(s)
Filed under: ,

Comments

elise said:

merci pour l'info ;)
# September 30, 2003 9:37 AM

Louise said:

does this work with VSS Version 5
# November 26, 2003 5:41 AM

Carleton Wong said:

It seems this does not work for me.
My sourcesafe is installed a different
machine from SQL server.

I have tried all your steps and failed.

Thanks
carletonwong@yahoo.com
# January 9, 2004 1:16 PM

Bryan Oliver said:

Have you tried mssqlXpress which provide so many advantages to SQL Developers.
# January 13, 2004 1:14 AM

Godders said:

Works well. Would be even better if you could group dbs under the same project as it seems to create a unique name if the project already exists. Otherwise no complaints.

- Nathan
# January 15, 2004 12:32 AM

Ben Zhang said:

go to
http://www.dotnet-tech.com/tutoriels/SQL-SourceSafe/

you are able to find out how to setup
# March 23, 2004 6:04 PM

Google it said:

You're a pretty high rank for the google search:

.NET "SourceSafe" SQL Server
# June 4, 2004 10:44 AM

Fabrice said:

That explains why this page is so visited :-)
The same for .NET CSV files
# June 4, 2004 10:56 AM

TrackBack said:

# August 7, 2004 12:54 PM

TrackBack said:

# August 8, 2004 5:19 AM

Siva said:

dear,

It's working fine for VS.NET 2003 VSS6.0 and SQL Server 2000.

But ,I need for the following configuration.

VS.NET2005 VSS6.0 and SQL Server 2005 please help if u can.

Thanks in advance.

Regards

Siva

# January 9, 2007 4:30 AM

Raluca said:

How can we set up VS.NET2005, VSS6.0 and SQL Server?

In VS2005 we do not have under Tools -> Options -> Database Tools any option for the Server Explorer to be added to VSS control.

Help will be really appreciated.

# April 24, 2007 12:11 PM

TJ said:

The original document on MicroSoft's site is here:  support.microsoft.com/.../818368  The steps are very detailed.

BUT, will this work for SQL Server version 7?  We are a bit out of date, I realize this, but the MS document says it works for 2000 and 2005, no mention of 7.  Has anyone gotten this to work with 7?  An answer would save me some time...  Thanks!

# October 2, 2007 2:33 PM

Raja said:

One stepwise detailed article on Source Control for Stored Procedure is avaialble here.

www.dotnetfunda.com/.../article21.aspx\

Thanks

# November 6, 2007 1:11 AM

dhruvin said:

thanks,

this is going to help a lot.

# November 26, 2007 7:40 AM

Priyanka said:

Is it possible to add the SQL 2000 SPs to VSS without having a domain setup?

# January 2, 2008 8:10 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)