Tracking Stored Procedure Changes

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Tracking Stored Procedure Changes

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-02-01 : 08:14:15

Alexander writes "I know that the stored procedure full text description, is saved in the system table "sysComments".
When a user of my work team edits an existing procedure and press the "Apply" button, the stored procedures is updated with the latest changes and the sysComments table is updated also.
I want to keep all the previous versions of the stored procedures. So i want to put a trigger to the SysComments table, in order to save the full text description of the stored procedure in a user Table. The result of this, will be to keep all the previous version of stored procedure and i will be able to keep a historical archive of sp changes.

Is there a way to put a user trigger on a system table? Can i track the sp change, with an another way?

Thanks"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-02-01 : 08:15:16

So, you want to keep a version of your source code ?

How about some source control ?

Damian