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%'