http://sqlblog.com/blogs/john_paul_cook/archive/2010/04/12/auditing-database-source-code-changes.aspxAuditing changes to database source code can be easily implemented with a database trigger. Here’s a simple implementation of stored procedure auditing using an audit table and a database trigger. It assumes that a schema named Audit already exists. CREATEenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/john_paul_cook/archive/2010/04/12/auditing-database-source-code-changes.aspx#27228Thu, 22 Jul 2010 09:23:05 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:27228how to backup old sp for alter stored procedure<p>how to backup old sp for alter stored procedure</p> http://sqlblog.com/blogs/john_paul_cook/archive/2010/04/12/auditing-database-source-code-changes.aspx#39811Tue, 15 Nov 2011 12:34:59 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:39811ravindra<p>hi</p> <p>The Above procedure will not work if i alter table in designer window i will get captured data like this &nbsp;ALTER TABLE dbo.Table_1 SET (LOCK_ESCALATION = TABLE) how to solve this issuce please reply.</p> http://sqlblog.com/blogs/john_paul_cook/archive/2010/04/12/auditing-database-source-code-changes.aspx#39812Tue, 15 Nov 2011 12:46:47 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:39812John Paul Cook<p>For a more timely and in-depth response, please post specific syntax questions in the MSDN forums: <a rel="nofollow" target="_new" href="http://social.msdn.microsoft.com/forums/en-US/transactsql/threads/">http://social.msdn.microsoft.com/forums/en-US/transactsql/threads/</a></p> <p>Because there are several factors that could come into play here, posting in a moderated forum is better.</p>