SQL－查询所有触发器

----查看所有角本
Create table #y (txt text)

select name, iid = identity(int,1,1) into #x from SysObjects where xtype = 'TR'

declare @i int, @max int
declare @name varchar(40)

set @i = 1
select @max = max(iid) from #x
while @i <= @max
begin
    select @name = name from #x where iid = @i
    insert #y (txt)
    exec('sp_helptext ' + @name)
    set @i = @i + 1
end

select * from #y

drop table #x
drop table  #y