Versioning Stored Procedures with VSS and Sql Server 2005

I am wanting to put my stored procs in vss. The configuration that I am looking at is

Sql Server 2005
Sql Server Management Studio
VSS

I have not been able to find anything that gets me going, so if someone has a link or some links, please just redirect me and I will continue digging.

What I don't know is what is the best approach for doing this. Do I need to create a new project in management studio for all of my stored procedures? Is there a solution that I can add to VS.NET that would do this? What I am ultimately looking to do if this is possible, is have my developers use Management studio to work on their procs and have it interact directly with VSS.

Any help is greatly apprecated.
Thanks in advance.

[738 byte] By [nebyeti] at [2008-3-6]

«« web projects, .net 1.1 and TFS?
»» project creation error

# 1

Hi,

Have you looked at these topics in Books Online?

How to: Use Source Control with SQL Server Management Studio
Source Control Basics (and the topics linked to in this topic)

Regards,

Gail

gaile at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Documentation...

# 2

Gail,

I have not looked at those. I will pull up Books Online and take a look. Should I have anymore questions, I will post them.

Thanks for the information,

Ben

nebyeti at 2007-9-9 >

# 3

Hi Ben,

Sounds good. BTW, I noticed that one of the topics I listed was updated in April, so I recommend that you download the April update to BOL from the download center http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en

Regards,

Gail

gaile at 2007-9-9 >

# 4

Hi,

we got something that does just that. check it out!

http://www.nobhillsoft.com/Randolph.aspx

let me know if you have any questions at: support@nobhillsoft.com

thanks

JonathanSion at 2007-9-9 >

SQL Server

SQL Server Documentation