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%'