SQL Server: DROP all triggers in a database
use your_database
DECLARE @exec SMALLINT
DECLARE @sql VARCHAR(500)
DECLARE @id INT
DECLARE @name VARCHAR(255)
SET @exec = 1
DECLARE gd CURSOR LOCAL FOR
SELECT TOP 1 name , id FROM sysobjects WHERE xtype = 'TR' ORDER BY id ASC
OPEN gd
FETCH NEXT FROM gd INTO @name , @id
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT '+++++++++++++++++++++++++++++++++++++++'
SET @sql = 'DROP TRIGGER ' + @name
PRINT '--->' + @sql
IF @exec = 1
EXEC( @sql )
FETCH NEXT FROM gd INTO @name , @id
END
Comments
Write the first comment
Leave a trace
Post being viewed right now
Item date: 22.11.2011
Views: 181
Views: 181
