At times there is a need to control
-- this trigger should be last in the execution chain sp_settriggerorder @triggername= '[dbo].[awesome_trigger]', @order='Last', @stmttype = 'UPDATE';
I usually don’ t see people put any way to prevent trigger nesting, example update trigger updating same records would fire the trigger again.
ALTER TRIGGER [dbo].[Awesome_Trigger] ON [dbo].[SecretTable] AFTER UPDATE AS BEGIN -- DO NOT CHANGE IF trigger_nestlevel() > 1 RETURN -- Do something clever SELECT 1 END