use [DataBase_Name] go SELECT * FROM sys.all_objects WHERE ([type] = ‘P‘ OR [type] = ‘X‘ OR [type] = ‘PC‘) ORDER BY [name]
sql中查看数据库中所有的存储过程
原文：http://www.cnblogs.com/qulianqing/p/7133800.html
