DDL Triggers

• Tknapik

  SSC Enthusiast

  Points: 118

  More actions

  October 18, 2006 at 3:15 pm

  #71037

  I have been given the task of archiving the code of various database objects as they are being updated. Triggers were brought up as a vehicle to accomplish this.  For example, is there any way to catch the code of a stored proc before it is altered, using a trigger?  I have been able to successfully catch the code that is being updated, however I can't find a way to capture the code pre-update.  Thanks for your help.

• Richard Josey

  Ten Centuries

  Points: 1076

  More actions

  October 19, 2006 at 4:53 am

  #666750

  If the trigger fires before the event then you can do an sp_rename on the original sproc.

  Just an idea, might not work.