Networking HowTos
Networking HowTos

List all Stored Procedures on a SQL Database

January 23, 2012 Database, Microsoft SQL

Ever wanted to know what stored procedures exist on a database, but don’t have access to the SQL managment tools? The script below will produce a list of all the stored procedures on the current database.

SELECT Name AS StoredProcedureName
FROM sys.objects
WHERE type='P'

You Might Also Like