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.

mssql trigger

How to check all triggers on MSSQL?

Join The Ride

Subscribe to our fortnightly newsletter with stories from our latest adventures and the best travel tips

Table of Contents