General discussion

  • Creator
    Topic
  • #2275183

    MS SQL 2000 and VSS 6.0

    Locked

    by hannahlovesbananas ·

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

    Thanks!

All Comments

  • Author
    Replies
    • #2700520

      Reply To: MS SQL 2000 and VSS 6.0

      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.

Viewing 0 reply threads