Filter the results of a stored procedure within t-sql

Posted by DanDan on Stack Overflow See other posts from Stack Overflow or by DanDan
Published on 2010-03-26T10:13:00Z Indexed on 2010/03/26 10:23 UTC
Read the original article Hit count: 403

Filed under:
|

I'm trying to get a list of stored procedures in t-sql. I am using the line:

exec sys.sp_stored_procedures;

I would like to filter the results back though, so I only get user created stored procedures. I would like to filter out sp_*, dt_*, fn_*, xp_* and everything else that is a system stored procedure and no interest to me. How can I manipulate the result set returned?

Using Sql Server 2008 express.

© Stack Overflow or respective owner

Related posts about stored-procedures

Related posts about tsql