Howtos / Articles

List all Stored Procedures on a SQL Database

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'…

Read more [...]