From the forum:
How to know programmatically about stored procedure parameters, their number and properties if I know its name. I suspect that there is some system procedure to give the answer but do not know.
You can do the following to know about sp parameters:
exec DB_TEST..sp_sproc_columns N'myproc2', N'dbo', N'DB_TEST', NULL, @ODBCVer = 3
How do I know ? Easily. Open the profiler and simply browse Query Analyzer. You can learn lots of things from there. :)
Friday, April 23, 2004 8:30 PM