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.
