Article ID: 154756 - View products that this article applies to.
This article was previously published under Q154756
Some programmers require the ability to list all of the stored procedures from a SQL Server database. The following example demonstrates how to use SQL syntax to instruct SQL Server to return information regarding the stored procedures and their parameters.
The following example uses RDO to create a list of the stored procedures held in the SQL Server pubs database:
For more information, please see the following articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/153234/EN-US/ ): How To Call System-Stored Procedures on SQL Server from RDO
(http://support.microsoft.com/kb/147875/EN-US/ ): How to Use "DS-Less" ODBC Connections with RDO and DAO
Article ID: 154756 - Last Review: July 13, 2004 - Revision: 4.2