Query to list all stored procedures

by

As Mike stated, the best way is to use information_schema. As long as you’re not in the master database, system stored procedures won’t be returned.

SELECT * 
  FROM DatabaseName.INFORMATION_SCHEMA.ROUTINES
 WHERE ROUTINE_TYPE = 'PROCEDURE'

If for some reason you had non-system stored procedures in the master database, you could use the query (this will filter out MOST system stored procedures):

SELECT * 
  FROM [master].INFORMATION_SCHEMA.ROUTINES
 WHERE ROUTINE_TYPE = 'PROCEDURE' 
   AND LEFT(ROUTINE_NAME, 3) NOT IN ('sp_', 'xp_', 'ms_')

More Related Contents:

  1. Comma separated results in SQL
  2. T-SQL stored procedure that accepts multiple Id values
  3. Understanding PIVOT function in T-SQL
  4. When should I use semicolons in SQL Server?
  5. How do I escape a percentage sign in T-SQL?
  6. Using RegEx in SQL Server
  7. Replace duplicate spaces with a single space in T-SQL
  8. How do you count the number of occurrences of a certain substring in a SQL varchar?
  9. Find index of last occurrence of a sub-string using T-SQL
  10. Hidden Features of SQL Server
  11. SQL Server 2008 Empty String vs. Space
  12. How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
  13. SQL Server: combining multiple rows into one row
  14. What is the Oracle equivalent of SQL Server’s IsNull() function?
  15. Can you call a webservice from TSQL code?
  16. How to add custom attributes to SQL connection string?
  17. SQL Recursive CTE: Finding objects linked by property
  18. Multiple Column Pivot in T-SQL
  19. Convert decimal time to hours and minutes
  20. Joining multiple tables returns NULL value
  21. Which join syntax is better?
  22. Compute MD5 hash of a UTF8 string
  23. LPAD in SQL Server 2008
  24. SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰
  25. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  26. How do I remove non-breaking spaces from a column in SQL server?
  27. How to wait for 2 seconds?
  28. How to set value to variable using ‘execute’ in t-sql?
  29. Update SQL with consecutive numbering
  30. Count number of records returned by group by

Leave a Comment