get stored procedure structure

[St]

Hello,

is it possible to get stored procedure from sql server ? For exemple, I am
using
GetSchemaTable to get schema from a table, but is it possible with a stored
procedure ?

Thanks

St

 

[Patrice]

AFAIK no "built-in ADO.NET support" but you can always select directly from
the Information_Schema.Routines view or call any sp you need (such as
sp_helptext to get the text of a SP).

Patrice

 

[Tapio Kulmala]

You could use SQL-DMO.


http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/sqldmo/dmoref_ob_s_14j8.asp


Tapio Kulmala