General discussion


MS SQL 2000 and VSS 6.0

By hannahlovesbananas ·
Is there any possible way to implement Stored Procedures into a VSS database for versioning? Has anyone heard of such a thing?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by MedievalDude In reply to MS SQL 2000 and VSS 6.0

Not directly. You could create a script for your procedures and save the scripted out files to some drive space. Then you could use version control over those files. With any change, you'd need to script it back out, check out the old file, replace it with the new one and check it back in. A bit of a pain.

Either that or just make sure you've got good nightly backups. That's a decent method to versioning sp's.

Collapse -

by MedievalDude In reply to

Related Discussions

Related Forums