SQL Server - Triggers

• jack20008

  Grasshopper

  Points: 16

  More actions

  April 9, 2009 at 4:36 am

  #130463

  Hi All

  I am using MS SQL, Sqlserver 2005 with C# code.

  I have two tables (table1 and table2).

  I need to setup a trigger on table1, so when record - Insert, Update and Delete is done it will then write the key of table1 to table2.

  Can any one help?

• Kruti Kansara

  Hall of Fame

  Points: 3118

  More actions

  April 9, 2009 at 5:02 am

  #974925

  hey, i hv to rush for meeting, so cannt explain much... but hope below links will help u...

  http://www.sqlservercentral.com/Forums/Topic351362-92-1.aspx#bm609225

  http://www.15seconds.com/Issue/041006.htm

  also, u can search on google for good example on trigger.

  "Don't limit your challenges, challenge your limits"

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  April 9, 2009 at 9:47 am

  #975174

  Search this site for "auditing triggers". Here you can find some great articles by GSquared:

  http://www.sqlservercentral.com/Authors/Articles/GSquared/475322/

  Greets

  Flo

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  April 9, 2009 at 10:16 am

  #975196

  Please no cross posts... All further posts please here:

  http://www.sqlservercentral.com/Forums/Topic693903-1291-1.aspx

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  April 9, 2009 at 10:16 am

  #975197

  -- DELETED ---