SQL Server question

[Bounty Bob]

Hi all,

Wasn't sure where to put this so here it is.

Is it possible in SQL Server 7.0 to extract stored procedure parameters from one of the system tables?

The reason I ask is that I've written an ADO class in VB and want to write a method to execute a stored procedure. I don't want the user to have to specify the size, type, etc for each parameter. I want them to be able to just pass values to the stored procedure and the class to determine what type it is.

Any thoughts greatly appreciated.

Rob

[Twodogs]

This works on Sybase - should also work on SQL Server

SELECT a.name 'procedure'
, b.colid 'position'
, b.name 'parameter'
, c.name 'type'
, b.length
, b.prec
, b.scale
FROM sysobjects a
, syscolumns b
, systypes c
WHERE a.id = b.id
AND b.usertype = c.usertype
AND a.type = 'P'
AND a.name like '%proc_name%'