Home  |  Articles  |  Scripts  |  Consultancy  |  FAQs  |  Links  |  SSIS

 
-- simple script to find potentially problematic triggers

SELECT * FROM sys.triggers
WHERE is_not_for_replication = 0
AND is_ms_shipped = 0