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: 2961 | Points: 40

sp_settriggerorder [triggername] first / last

example :

USE AdventureWorks2008R2;

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