Consultar Trigger, Procedure de una DataBase – SQL Server

SELECT
    Object_name(so .parent_object_id) Parent_Name,
    so .name ObjectName,
    so .type_desc [Type Description],
    so .create_date [Create Date],
    sm.definition [Text]
FROM   sys .objects so
INNER JOIN sys. sql_modules sm
ON so.object_id = sm.object_id
WHERE  so .type = 'TR'

go
SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_TYPE = 'PROCEDURE'
ORDER BY ROUTINE_NAME

go
SELECT [name], [object_id], [create_date], [modify_date]
  FROM sys.all_objects 
 WHERE [type] = 'P' AND [object_id] > 0