Check if Trigger exists in SQL

SELECT * FROM sys.triggers, will return a table that contains a row for each object that is a trigger, with a type of TR or TA.

SELECT count(*) FROM sys.triggers where name = 'MyTrigger', can be used if one need to look if a particular trigger exists or not. The above line of code will return a 0 if the specified trigger is not present, otherwise 1 will be returned.

One can also use

    SELECT * FROM sys.triggers 
    WHERE object_id = OBJECT_ID(N'[dbo].[trgrName]')

All of the above method are valid for all versions of SQL Server.