查询指定库中的用户存储过程

 

 

 select name from [数据库名字].[dbo].sysobjects
    where type='P' and name not like 'sp_%' and name not like 'dt_%'
    order by name