Can you set firing order in triggers and in instead of triggers?

 Posted by Bhaskara on 5/4/2011 | Category: Sql Server Interview questions | Views: 3223 | Points: 40
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 

Comments or Responses

Login to post response

More Interview Questions by Bhaskara