Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
T-SQL Enable All Triggers
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment