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]
23. April 2012
Anil Kumar
MS-SQL
Triggers are used to implement business rules, automate or to enforce referential integrity in database applications. Some important points/info about Triggers are -1) Avoid using cursor in Triggers.2) Avoid executing many sql statements on other tables also.3) Avoid returning multi-row-results...
[More]