mssql trigger

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],
            c.[text]
FROM        sys.objects AS o
INNER JOIN  sys.syscomments AS c
ON      o.object_id = c.id
WHERE   o.[type] = 'TR'

I note this tip so I may refer it when doing support our retailer customers.

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email