下面将返回所选数据库中的所有过程

SELECT * FROM sys.procedures

这将显示所有的存储过程和代码:

select sch.name As [Schema], obj.name AS [Stored Procedure], code.definition AS [Code] from sys.objects as obj
    join sys.sql_modules as code on code.object_id = obj.object_id
    join sys.schemas as sch on sch.schema_id = obj.schema_id
    where obj.type = 'P'

exec sp_stored_procedures; Docs.Microsoft.com

很容易记住。

select *  
  from dbo.sysobjects
 where xtype = 'P'
   and status > 0

SELECT name, 
       type
  FROM dbo.sysobjects
 WHERE (type = 'P')

不幸的是，INFORMATION_SCHEMA不包含系统进程的信息。

SELECT *
  FROM sys.objects
 WHERE objectproperty(object_id, N'IsMSShipped') = 0
   AND objectproperty(object_id, N'IsProcedure') = 1