Forcing Trigger Firing Order in SQL Server

sp_settriggerorder Parameters exec sp_settriggerorder @triggername = , /* SQL Server 2000 and 2005 */ @order = [FIRST|LAST|NONE], /* SQL Server 2000 and 2005 */ @stmttype = [INSERT|UPDATE|DELETE|], /* SQL Server 2000 and 2005 */ @namespace ...

www.mssqltips.com