I have been wanting to put stored procedures
in our current project under source control. Although changes to SPs
will be minimal, we all know what we can get when we keep history of
parts of our code and the ease of comparing them side by side.
Searching usenet as usual, it brought me to this KB:
How To Add SQL Server 2000 Stored Procedures to Visual SourceSafe by Using Visual Studio .NET
I've
tried the above procedures but I can't seem to make it work, and
besides, a teammate of mine is working on our server box so I can't eat
up much of his time. Until I accidentally saw the DB projects
supported by VS2003 under its "Other Projects" category. I added our
SQL server and quickly generated scripts for all of our SPs and added
them to source control. Now I'm happy...