Automate Triggers to work for all tables

• daniarchitect

  SSCommitted

  Points: 1727

  More actions

  June 28, 2010 at 5:35 pm

  #226261

  Hi All,

  Here is whats happening , my manager asked me to create trigger which writes both what is inserted and/or updated record whenever a table gets updated.and I have done that for a single table.But he wanted to create a single trigger which does the same for all 52 tables which ofcourse have different structures.someone suggested to get Table names and column names from sysObjects...and it is very urgent......

  your valuable ideas please.

  Thanks

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 29, 2010 at 1:46 am

  #1186204

  Duplicate post.

  Replies here please: http://www.sqlservercentral.com/Forums/FindPost944341.aspx

  -- Gianluca Sartori