T-SQL Enable All Triggers

EnableAllTriggers.sql

CREATE PROCEDURE [dbo].[EnableAllTriggers]

AS

DECLARE @string VARCHAR(8000)

DECLARE @tableName NVARCHAR(500)

DECLARE cur CURSOR

FOR SELECT name AS tbname FROM sysobjects WHERE id IN(SELECT parent_obj FROM sysobjects WHERE xtype='tr')

OPEN cur

FETCH NEXT FROM cur INTO @tableName

WHILE @@fetch_status = 0

BEGIN

SET @string = 'Alter table ' + @tableName + ' Enable trigger all'

EXEC (@string)

FETCH NEXT FROM cur INTO @tableName

END

CLOSE cur

DEALLOCATE cur


GO