查看SQL SERVER指定数据库中所有的触发器

SELECT * FROM Sysobjects WHERE xtype = 'TR'

		

use ReportServer
go

SELECT tb2.name AS tableName,tb1.name AS triggerName FROM Sysobjects tb1 
JOIN Sysobjects tb2 ON tb1.parent_obj=tb2.id WHERE tb1.type='TR'