Get stored procedure metadata

  • Thread starter Thread starter David Thielen
  • Start date Start date
Frankly, I don't recall the name of the stored procedure to do this but if
you turn on the profiler and run Visual Studio and inspect the properties of
a SP in the Server explorer, you'll see VS use it.

David Thielen said:
Hi;

How can I query SqlServer to get back for each stored procedure in a
database:
each parameters name, type, default (does it have one, what is it),
and if it's input/output/both
does it have a return value and if so, it's type.

thanks - dave

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm
Click to expand...

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
____________________________________________________________________________________________
 
Back
Top