title: How do I get the list of all stored procedures and their parameters starting with a certain prefix?
body: <p>Is there a way to query the database and retrieve a list of all stored procedures and their parameters?<br>
  I am using SQL Server 2000.</p>