What sp_settriggerorder stored procedure does?

89.

Sets the order for an AFTER trigger

Sets the order for an INSTEAD OF trigger

Sets the order for all kind of triggers

To specify the order for an AFTER trigger, use the sp_settriggerorder stored procedure. INSTEAD OF triggers cannot be specified as first or last triggers. INSTEAD OF triggers are fired before updates are made to the underlying tables