InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 03:47:00 GMT20http://www.sqlservercentral.com/Forums/Topic449718-576-1.aspxRefer Here:[url=http://jjeyakumar.blogspot.com/2011/01/useful-ms-sql-statement-for-triggers.html][/url]Tue, 18 Jan 2011 09:46:33 GMTj.jeyakumarhttp://www.sqlservercentral.com/Forums/Topic449718-576-1.aspxI have updated the initial query so that it will indicate the enabled/disabled triggers in a SQL Server 2005 database.[quote] SELECT T.[name] as TableName, TR.[Name] as TriggerName, CASE WHEN 1=OBJECTPROPERTY(TR.[object_id], 'ExecIsTriggerDisabled') THEN 'Disabled' ELSE 'Enabled' END StatusFROM 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];[/quote]Fri, 21 Mar 2008 07:56:09 GMTRalph D. Wilson IIhttp://www.sqlservercentral.com/Forums/Topic449718-576-1.aspxHi I have this command that is more simple EXECUTE sp_msforeachtable "ALTER TABLE ? disable trigger ALL"AdrianThu, 20 Mar 2008 06:57:07 GMTAdrian Aleksandrowicz-276567http://www.sqlservercentral.com/Forums/Topic449718-576-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/T-SQL/62092/">Enable Disable All Triggers in a Database</A>[/B]Wed, 30 Jan 2008 15:20:12 GMTDanny Ocean