fire trigger asynchron?

• teutales

  Say Hey Kid

  Points: 671

  More actions

  June 30, 2010 at 3:05 am

  #222772

  Hi folk,

  example:

  TABLE A has a Trigger: AFTER INSERT

  Prozedure proc do

  INSERT INTO TABLE A

  Do some other thinks

  Problem is:

  When proc is running it waits after the insert for the trigger. Is it possible to fire the trigger asynchron?

• DM Unseen

  SSC Veteran

  Points: 260

  More actions

  June 30, 2010 at 3:38 am

  #1186942

  Kink of a job in the SQL server agent that runs your SQL. This is async.

  Kind Regards,

  DM Unseen AKA M. Evers

• Dave Ballantyne

  SSC-Dedicated

  Points: 33566

  More actions

  June 30, 2010 at 3:40 am

  #1186943

  You could investigate service broker.

  ---

  
  Clear Sky SQL
  My Blog[/url]