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
You can’t perform that action at this time.