Find all triggers in database
snippet in sql

Find all triggers in database

user1450

SELECT  
    name,
    is_instead_of_trigger
FROM 
    sys.triggers  
WHERE 
    type = 'TR';