Update Trigger in sql 2005

• ishaan99

  SSCertifiable

  Points: 6261

  More actions

  July 5, 2011 at 9:03 am

  #99742

  I am trying to get the update trigger work on specific tables in my database. my requiremnet is if any cols of a table are updated then insert the updated record into a new table as <TABLENAME>_updated. This table is a replica of actual table in terms of structure. is it possible to get this working? any help on this is greatly appreciated.

  TIA

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 5, 2011 at 9:51 am

  #1348386

  Yes, that's usually pretty easy to set up.

  Are you running into a problem with your trigger? Or are you just not sure where to start?

  - 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