SQL Stored Procedures Code Control

I have several programmers that work on our SQL Server database. There have been several occasions that a stored procedure has been corrupted and we have to go through the pain staking process of restoring a backup to get the information. This program utilizes Visual SourceSafe and SQL Server to copy stored procedures to SourceSafe. I run this program daily to make sure I capture all changes. This allows me to analyze what is different about a stored procedure and allows me to roll back to a earlier version. This process does not tell me who corrupted the stored procedure. I have other ways of getting that. Hope this helps you. Take care