eamonroche
SSCommitted
Points: 1678
More actions
February 26, 2003 at 6:13 am
#79725
Is there a way, using asp scripting, that I can display a stored procedure code in my web browser.
Andy Warren
SSC Guru
Points: 119902
February 26, 2003 at 7:30 am
#449765
Just select the appropriate row from syscomments and return as a recordset.
Andy
http://www.sqlservercentral.com/columnists/awarren/
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Greg Larsen
SSC-Insane
Points: 20961
February 26, 2003 at 8:41 am
#449771
You might also try:
sp_helptext <your sp>
This sp will return the the code for the SP.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply