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).
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.
DECLARE @id AS INT,@objectName AS NVARCHAR(128)
SET @objectName = N'dbo.triggerA'
SELECT @id = OBJECT_ID(@objectName)
SELECT OBJECTPROPERTY(@id, 'ExecIsFirstDeleteTrigger') AS ExecIsFirstDeleteTrigger,
OBJECTPROPERTY(@id, 'ExecIsFirstUpdateTrigger') AS ExecIsFirstUpdateTrigger,
OBJECTPROPERTY(@id, 'ExecIsFirstInsertTrigger') AS ExecIsFirstInsertTrigger,
OBJECTPROPERTY(@id, 'ExecIsLastDeleteTrigger') AS ExecIsLastDeleteTrigger,
OBJECTPROPERTY(@id, 'ExecIsLastUpdateTrigger') AS ExecIsLastUpdateTrigger,
OBJECTPROPERTY(@id, 'ExecIsLastInsertTrigger') AS ExecIsLastInsertTrigger
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