Answer: sp_settriggerorder [triggername] first / last
example :
USE AdventureWorks2008R2;
GO
sp_settriggerorder @triggername= 'Sales.uSalesOrderHeader', @order='First', @stmttype = 'UPDATE';
For instead of trigger we cannot be set the order.
Asked In: Many Interviews |
Alert Moderator