Enable Disable All Triggers in a Database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by vinaykumar » Enable Disable All Triggers in a Database

Enable Disable All Triggers in a Database

Rate Topic

Display Mode

Topic Options

Author

Message

Danny Ocean

Posted Wednesday, January 30, 2008 3:20 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 4:55 AM
Points: 1,085, Visits: 1,164

Comments posted to this topic are about the item Enable Disable All Triggers in a Database

Keep Learning - Keep Growing !!!
http://growwithsql.blogspot.in

Thanks
Vinay Kumar

Post #449718

Adrian Aleksandrowicz-276567

Posted Thursday, March 20, 2008 6:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, August 15, 2012 10:54 AM
Points: 1, Visits: 138

Hi
I have this command that is more simple

EXECUTE sp_msforeachtable "ALTER TABLE ? disable trigger ALL"

Adrian

Post #472207

Ralph D. Wilson II

Posted Friday, March 21, 2008 7:56 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, March 05, 2009 10:58 AM
Points: 62, Visits: 38

I have updated the initial query so that it will indicate the enabled/disabled triggers in a SQL Server 2005 database.

SELECT T.[name] as TableName,
TR.[Name] as TriggerName,
CASE WHEN 1=OBJECTPROPERTY(TR.[object_id], 'ExecIsTriggerDisabled')
THEN 'Disabled'
ELSE 'Enabled'
END Status
FROM sys.objects T
INNER JOIN sys.triggers TR
ON T.[object_id] = TR.parent_id
WHERE (T.type = 'U' or T.type = 'V')
ORDER BY T.[name], TR.[name];

Post #472810

j.jeyakumar

Posted Tuesday, January 18, 2011 9:46 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 18, 2011 9:45 AM
Points: 1, Visits: 0

Refer Here:

[url=http://jjeyakumar.blogspot.com/2011/01/useful-ms-sql-statement-for-triggers.html][/url]

Post #1049485

« Prev Topic | Next Topic »

Permissions