I was looking for SQL Server diagram understanding and found a good article on Atif Shehzad.One can find and read this nice article - Getting started with SQL Server database diagrams
We can use sys.triggers view (object schema view) to know the status of trigger(s) in a database.
USE [myDatabaseName]
GO
SELECT * FROM sys.triggers
WHERE [is_disabled] = 1 ; -- 0:Enabled and 1:Disabled
To get the status of a particular trigger:
SELECT * FROM sys.triggers
WHER...
[More]
Two easiest command syntacx to disable /enable existing triggers on table are as below-
To Disable-
ALTER TABLE [mySchemaName].[myTableName] DISABLE TRIGGER myTriggerName
OR
DISABLE TRIGGER myTriggerName ON [mySchemaName].[myTableName]
To Enable-
ALTER TABLE [...
[More]