This may work better for the trigger references:

SELECT DISTINCT SUBSTRING( SO.NAME, 1, 60 ) AS [Trigger Name]

FROM sysobjectsAS SO

JOIN syscommentsAS SC

ON SO.ID = SC.ID

WHERE SO.XTYPE = 'TR'

AND SC.Text LIKE '%' + @vcColumnName + '%'

AND ( @vcTableName = '' OR OBJECT_NAME( SO.Parent_Obj ) = @vcTableName )

ORDER BY [Trigger Name]