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 a peek at DTS to export objects, and pick SP's only,
but as soon as I select text file for the destination, the Objects
option is greyed out.
Anybody know if such an animal exists in MSSQL natively, or any thoughts
on how this could efficiently be done. Once I have them in there, I
would like to be able to check them out, make changes and check in as
painlessly as possible.
Dan
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- RE: Storing SQL SP's in VSS] Dan O'Keefe
- RE: Storing SQL SP's in VSS] Qasim Rasheed
- Re: Storing SQL SP's in VSS] Dan O'Keefe
- RE: Storing SQL SP's in VSS] Michael Wolfe
- Re: Storing SQL SP's in VSS] Dan O'Keefe