Listar procedures, views e funções existentes no database selecionado utilizando o SQLServer
SELECT
name AS ObjectName,
schema_name(schema_id) AS SchemaName,
type_desc AS ObjectType,
create_date,
modify_date
FROM
sys.objects
WHERE
type IN ('P', 'V', 'FN') -- 'P' para Procedures, 'V' para Views, 'FN' para Functions
ORDER BY
SchemaName,
ObjectName;