InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 19:13:51 GMT20http://www.sqlservercentral.com/Forums/Topic903710-2675-1.aspxsp_msforeachtable is a better option.sp_msforeachDb is another useful procedure.Thu, 22 Apr 2010 23:04:28 GMTAtif-ullah Sheikhhttp://www.sqlservercentral.com/Forums/Topic903710-2675-1.aspx[font="Verdana"][code="other"]SELECT 'ALTER TABLE ['+ SC.NAME+'].[' + PB.NAME + '] ENABLE TRIGGER ALL' FROM SYS.TRIGGERS TJOIN SYS.ALL_OBJECTS OB ON OB.OBJECT_ID = T.OBJECT_IDJOIN SYS.ALL_OBJECTS PB ON PB.OBJECT_ID = OB.PARENT_OBJECT_IDJOIN SYS.SCHEMAS SC ON SC.SCHEMA_ID = PB.SCHEMA_ID [/code]is this will be enough ? or even efficient?[/font]Mon, 19 Apr 2010 01:06:39 GMTAbrar Ahmad_http://www.sqlservercentral.com/Forums/Topic903710-2675-1.aspxThanks Jammie,That will definately work as well in both 2005 and 2008 as the system stored procedure sp_msforeachtable is included in the latest version, and intelli sense actually pick it up, well spotted.Sun, 18 Apr 2010 23:59:59 GMTtsepohttp://www.sqlservercentral.com/Forums/Topic903710-2675-1.aspxHi there,Another way that I use which I think will do the same thing is:--Disable all triggerssp_msforeachtable "ALTER TABLE ? Disable TRIGGER all"Then when your ready to enable them again:--Enable all triggerssp_msforeachtable "ALTER TABLE ? Enable TRIGGER all"I've used this plenty of times in SQL2005 and although I haven't tried in 2008 as yet, I expect it will work.Sun, 18 Apr 2010 23:50:42 GMTJamie Burmeisterhttp://www.sqlservercentral.com/Forums/Topic903710-2675-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Disable+%2f+Enable+All+triggers/70031/">Disable / Enable All triggers on all tables in sql server 2005</A>[/B]Wed, 14 Apr 2010 19:43:34 GMTtsepo