To get a list of all storedprocedures in a Database you can use te following snippet.
Sample SQL
select * from Testdatabase.information_schema.routines where routine_type = 'PROCEDURE' ORDER BY ROUTINE_NAME ASC
One thought on “How to get a list of all storedprocedures in a Database”
Leave a Reply
You must be logged in to post a comment.
RT @CodeSnippetsNET: List all storedprocs in #mssql #Database
http://t.co/zGC2mSKlND #sql #coding