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: 736255
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply