trigger order
mulmad
Posts: 94
I unsure if after trigger execution order (set by using sp_settriggerorder) is syncronised between instances? (I'm not even sure where this info is stored).
Comments
The objectproperty system function allows you to query the trigger order of any trigger. So if you want to independently verify that the trigger order has been updated the following code can be used, just change the object name from dbo.triggerA to your trigger's name.
Hope this helps,
Regards,
Jonathan
-Project Manager
-Red Gate Software Ltd