Show Stored Procedure Code 2

[astrodestino]

Hi!
I'm not into SQL programming and with help of you guys I created my first stored procedure.
Now I can call it any time from my website but since I dont have the sql enterprise manager at home I was trying to make an application like enterpriese manager but in asp.
I created stored procedures with CREATE PROCEDURE and deleted with DROP PROCEDURE but how do I read the stored procedure code? I couldnt find SHOW PROCEDURE or something like that.
Can that be done?
Thank you very much!!

 

[chmohan]

sp_helptext urprocedurename in sql query analyzer

see this

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

 

[astrodestino]

Tnx!!

 

[fredericofonseca]

note that if the SP was created with encryption you won't be able to retrieve the text.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com