OT: Storing SQL SP's in VSS]

I want to store my MSSQL 2K(SP3a) SP's in VSS and trying to think of a way to do it. First thought was to find an existing system SP if it existed, that I could loop over all of the SP's and just retrieve the text of the SP, not execute it. I could then write those out to text files. Also took

RE: OT: Storing SQL SP's in VSS

Why not just select the SP, generate script, then stored the generated script in a VSS project.   If you need to make a change, c/o the script, make your change, execute it, then check it back in. If you find a tighter integration then this, I'd like to hear about it.  But that's what we do here.

Re: OT: Storing SQL SP's in VSS

Suyer, Ed wrote: > Why not just select the SP, generate script, then stored the generated > script in a VSS project.   > > If you need to make a change, c/o the script, make your change, > execute it, > then check it back in. > > If you find a tighter integration then this, I'd like to hear about