Software

Ask something
Discussion Locked

MS SQL 2000 and VSS 6.0

0 helpful
2 replies

by hannahlovesbananas

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

Thanks!

2 replies

by medievaldude

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.

This discussion is closed to new replies.