text: -- Триггеры
  
  SELECT  @@Servername AS ServerName ,
          DB_NAME() AS DBName ,
          parent.name AS TableName ,
          o.name AS TriggerName ,
          o.[Type] ,
          o.create_date
  FROM    sys.objects o
          INNER JOIN sys.objects parent ON o.parent_object_id = parent.object_id
  WHERE   o.Type = 'TR' -- Triggers 
  ORDER BY parent.name ,
          o.NAME 
  
  --OR 
  
  SELECT  @@Servername AS ServerName ,
          DB_NAME() AS DB_Name ,
          Parent_id ,
          name AS TriggerName ,
          create_date
  FROM    sys.triggers
  WHERE   parent_class = 1
  ORDER BY name;
  
  --OR 
  -- Дополнительная информация о триггерах
  
  SELECT  @@Servername AS ServerName ,
          DB_NAME() AS DB_Name ,
          OBJECT_NAME(Parent_object_id) AS TableName ,
          o.name AS 'TriggerName' ,
          o.Type ,
          o.create_date ,
          sm.[DEFINITION] AS 'Trigger script'
  FROM    sys.objects o
          INNER JOIN sys.sql_modules sm ON o.object_id = sm.OBJECT_ID
  WHERE   o.Type = 'TR' -- Triggers 
  ORDER BY o.NAME;
  
  GO