Have Geek Brain

Track all versions of a stored procedure that change multiple times

If a stored procedure has changed 10 times, I want to register or track it in a table in a 10 row column from the initial stored procedure to the latest version, which is 10 different versions of the same stored procedure, can anyone suggest how to do this ?

0


a source to share


3 answers


You won't tell which version of SQL server you are using, but have you looked at DDL triggers?



+1


a source


I know I'm not answering your question directly, but have you considered using a source control tool for it? Like svn, a safe source, ...



0


a source


If you are using dot net it will be helpful to create a database project where you can store SP as well as scripts for all other objects and use some control source where you can maintain version history.

0


a source






More articles:


All Articles