MSSQL导出全部触发器脚本

IF OBJECT_ID('tempdb..#TempTriggerScripttable') IS NOT NULL

DROP TABLE #TempTriggerScripttable

CREATE table #TempTriggerScripttable([text] text)

GO

DECLARE Cur_TemTrigger CURSOR

FOR

    select name from sysobjects where xtype='TR'

OPEN Cur_TemTrigger

DECLARE @Name VARCHAR(2000)

FETCH NEXT FROM Cur_TemTrigger INTO @Name

WHILE @@FETCH_STATUS = 0

    BEGIN

insert into #TempTriggerScripttable([text]) exec sp_helptext @Name

insert into #TempTriggerScripttable([text]) SELECT 'GO'

        FETCH NEXT FROM Cur_TemTrigger INTO @Name

    END

CLOSE Cur_TemTrigger

DEALLOCATE Cur_TemTrigger

SELECT * FROM #TempTriggerScripttable