Multiple Triggers

• Johnny Doyle

  Right there with Babe

  Points: 745

  More actions

  August 22, 2002 at 9:42 am

  #173324

  I want to have two update triggers on a table in SQL 7.0. How can I define which trigger is called first ? All my tests have shown that the triggers are run in the order that they're created, but I can't find this written anywhere. Is this so ?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737630

  More actions

  August 22, 2002 at 10:08 am

  #435075

  Not sure about 7. In 2000, there is sp_settriggerorder.

  It also mentions that AFTER triggers are fired in random order.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones