I met some errors today when working on the Microsoft Dynamic RMS database because they customized it and added some triggers. I must check where the triggers are defined to fix the issue, and this is the query I made.
Check all triggers on MSSQL:
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 to it when providing support to our retail customers.