Trigger on the table

• ssismaddy

  SSCarpal Tunnel

  Points: 4850

  More actions

  October 26, 2009 at 1:51 pm

  #385653

  Hi, We have a table in SQL 2005 and whenever a column in the table is updated we want to log in to a separate table. I m planning to create a trgger for this. Can anyone suggest how can we do this using triggers??

  Thank you

• GSquared

  SSC Guru

  Points: 260824

  More actions

  October 26, 2009 at 2:12 pm

  #1070915

  Check these:

  http://www.sqlservercentral.com/articles/Auditing/63247/

  http://www.sqlservercentral.com/articles/Auditing/63248/

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon