Query to display triggers on Sql Server

List the existing triggers: Select * from sysobjects where type = 'TR'  order by Name Specififc Trigger Select Text from syscomments where Text like '%CompanyPerson%'