Retrieving a filtered list of stored procedures using 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/04/27
9:03 UTC
Read the original article
Hit count: 333
Filed under:
stored-procedures
|tsql
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.
Solved! Here is what I used:
SELECT name FROM sys.procedures
WHERE [type] = 'P'
AND name NOT LIKE 'sp_%'
AND name NOT LIKE 'dt_%'
ORDER BY name ASC;
© Stack Overflow or respective owner
