to see also the concerned table:

SELECT ta.name AS

, tr.name AS [trigger name]

FROM dbo.sysobjects tr

INNER JOIN dbo.sysobjects ta ON tr.parent_obj = ta.id

WHERE tr.xtype...