Tag Archives: Trigger

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…