Get stored procedure metadata

[David Thielen]

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

 

[William Vaughn \(MVP\)]

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.

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

--
__________________________________________________________________________
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
____________________________________________________________________________________________

 

[John]

You may want to check out this post:

http://aspadvice.com/blogs/azamshar...qlCommandBuilder.DeriveParameters-Method.aspx