Can I place my Stored Procedures in VSS

[essa2000]

Dears ,
I want to know that can I work with VSS in SQL Server. I want to place my Stored Procedures in Visual Sources Safe and check out in Stored Procedure Editor.

essa2000

 

[bbturner]

Yes, you may place your Stored Procedures in Visual Source Safe.

 

[foxdev]

To follow up on bbturner's comment, you can place any kind of file in VSS, including .SQL files you've saved out of a tool like Query Analyzer. Its not really the stored procedure itself, but a script that will create the SP.

and check out in Stored Procedure Editor.

I don't know about SQLS 2000, but that's not possible in v7, except for the technique I described in the first paragraph.
Robert Bradley

http://www.foxdev.com/

Do you have too much money? Visit

http://www.agrainofhope.org

 

[bbturner]

But remember -- (as I just read in a Text Book for SQL Server 7 & 2000).. Stored Procedures themselves do not avail themselves to self-administering versioning - yet.