列出SQL Server 2005中存在的所有储存过程?用户自定义存储过程?

列出SQL Server 2005中存在的所有储存过程?

USE [your_database_name_here];   
GO   
SELECT * FROM sys.all_objects   
WHERE ([type] = 'P' OR [type] = 'X' OR [type] = 'PC')   
ORDER BY [name];   
GO

用户自定义存储过程?

USE [your_database_name_here];   
GO   
SELECT * FROM sys.all_objects   
WHERE ([type] = 'P' OR [type] = 'X' OR [type] = 'PC')   
AND [is_ms_shipped] = 0   
ORDER BY [name];   
GO