Mssql’de kayıtlı triggerları listeleme

SELECT   ParentObject = o.name,TriggerName = t.name,[Type] = t.type,TypeDesc = t.type_desc
 FROM     sys.triggers t LEFT JOIN sys.objects o ON t.parent_id = o.object_id
 WHERE    t.is_ms_shipped = 0
 ORDER BY [Type],ParentObject,TriggerName