sys.sp_settriggerorder

Description

triggers that are fired first or last. The triggers that are fired between the first and last triggers are executed in undefined order.

Syntax

sp_settriggerorder
[ @triggername = ]
N
'triggername'
, [ @order = ]
'order'
, [ @stmttype = ]
'stmttype'
[ , [ @namespace = ]
'DATABASE'
|
'SERVER'
|
NULL
]
[ ; ]