Home Forums Article Discussions Article Discussions by Author Discuss content posted by George Varkey Search All Stored Procedures in a Database RE: Search All Stored Procedures in a Database

  • September 30, 2009 at 3:34 am

    #1059859

    Assuming this post belongs to SQL server 2005, you can use the below query to return all SP in the database

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

    Abhijit - http://abhijitmore.wordpress.com