View Stored Procedures in MS SQL Server

sqlserver-view-stored-procedures.sql

-- SQL Server: query all stored procedures in all databases
 
DECLARE @sql varchar(1000)
 
select @sql = 'use ? select
 [database name] = db_name() 
,[schema name] =  SCHEMA_NAME([schema_id])
,name [stored proc name]
,create_date [create date]
,modify_date [last modify date]
from sys.objects
where type = ''P''
and db_name() not in (''master'',''msdb'',''model'',''tempdb'')
order by [create date] desc
--order by [last modify date] desc'
 
EXEC sp_MSforeachdb @sql