stored procedures

How to get listing of stored procedures for SQL server database

Just a quick note on how to¬†get listing of stored procedures for SQL server database. Following query will do this for you (as long as you’re not in the master database, system stored procedures won’t be returned): \n\n SELECT *\nFROM DatabaseName.information_schema.routinesWHERE routine_type = ‘PROCEDURE’ You may add AND¬†specific_name LIKE ‘%part_of_specific_name%’ to WHERE clause to filter/look How to get listing of stored procedures for SQL server database