SQL Server: check whether a Trigger is Enabled or Disabled? March 20, 2023 by Tarik Using sys.triggers SELECT name, is_disabled FROM sys.triggers