Plamen,

Yes I know how to use Command object to "add" SPs and invoke it but I wanted to know if there is a way to "query" the parameters to determine what parameters the SP requires.

>Is there a way to dynamically query parameters of a MSSQL stored proc using ADO?
>
>You must use Command object to invoke SP. Use its Parameters collection to append parameters for input, output and result of SP. In MSDN, see "Parameter Object (ADO)" and "Parameters Collection (ADO)" topics.