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...