查看当前库中所有的触发器，显示触发器的定义

--查看当前库中所有的触发器:
SELECT top 10 * FROM Sysobjects

SELECT * FROM Sysobjects WHERE xtype = 'TR' AND name LIKE 'tr_Sduept%' ORDER BY name

--显示触发器的定义:
EXEC sp_helptext 'tr_Sduept_bas_part_ALL'