Triggers

• ekknaveen

  SSCrazy

  Points: 2317

  More actions

  December 1, 2009 at 11:56 pm

  #140428

  I had two triggers update and delete on xyz table. I created another trigger for insert on the same (xyz) table. But this is executing after 5 minutes of inserting a record.

  Can anyone tell me what to do to get it executed as soon as a record is inserted.

  Thanks in advance

  Regards,

  Naveen

• dmoldovan

  SSCertifiable

  Points: 6334

  More actions

  December 2, 2009 at 1:57 am

  #1086306

  Can you give more details about what you want to achieve?

• dmoldovan

  SSCertifiable

  Points: 6334

  More actions

  December 2, 2009 at 2:54 am

  #1086325

  ...and also see http://www.mssqltips.com/tip.asp?tip=1409

• Dugi

  SSCoach

  Points: 17998

  More actions

  December 2, 2009 at 5:50 am

  #1086395

  ekknaveen (12/1/2009)

  ---

  I had two triggers update and delete on xyz table. I created another trigger for insert on the same (xyz) table. But this is executing after 5 minutes of inserting a record.

  Can anyone tell me what to do to get it executed as soon as a record is inserted.

  Thanks in advance

  Regards,

  Naveen

  Did you insert the record with SP or using application or just testing insert record with T-SQL!?

  Let us know about your trigger that you created for that table...!:hehe:

  ============================================================
  SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
  http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]