Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The

Version Control from Query Analyzer

Even though Query Analyzer itself has no built-in support for version control, you can use command-line utilities in conjunction with Query Analyzer's ability to run custom tools to add version control facilities to the environment. If your source code management system includes a command-line utility for performing code management tasks (most do), you can hook that utility into Query Analyzer's Tools menu. Moreover, because Query Analyzer provides special runtime tokens that allow you to pass the name of the current file (and many other key elements) to an outside tool, you can wire your version control tool almost seamlessly into the development environment.

As I've said, I use VSS, so the steps that follow ...