Getting stored procedure script

[jafisher2000]

Does anyone know how to get the create statement for a stored procedure programmatically using system tables and/or stored procedures. Actually any method except using DMO. I want to use .NET as the language that reads the information

 

[vidru]

sp_helptext ProcName

--dave

 

[jonyeh]

I never did this, but I imagine it is not too difficult to use the sp_Helptext stored procedure to get the sql code of a stored procedure, with which if you look into the source code of this stored procedure, it is using the syscomments table to get the text of the stored procedure.