how to check all triggers on MSSQL?

December 16, 2019 in Database

how to check all triggers on MSSQL?
I met some errors today when working on Microsoft Dynamic RMS database because they customized it and add some triggers. I must check where the triggers defined to fix the issue and this is the query I made.
SELECT      o.[name],
FROM        sys.objects AS o
INNER JOIN  sys.syscomments AS c
ON      o.object_id =
WHERE   o.[type] = 'TR'
I note this tip so I may refer it when doing support our retailer customers.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.