How to capture the old version of an SP, View or Function in a DDL trigger

• Roust_m

  SSCoach

  Points: 17402

  More actions

  June 3, 2010 at 12:40 am

  #141267

  Hi,

  Just wondering if you can capture the old version of an object inside a DDL trigger? I've tried to do a select from sysmodules, but got the new version of the object. "Instead Of" option for a DDL trigger does not seem to work.

  Any ideas?

  Thanks.

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  June 3, 2010 at 6:07 am

  #1175871

  i dont think you can see the older version of Sp unless you are preserving it in Audit table with the help of DDL trigger.

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• daxz

  SSC Veteran

  Points: 264

  More actions

  June 3, 2010 at 10:56 am

  #1176087

  there is a good article on this at http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes