Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 procedure body

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-18 : 08:13:25
Ramchander writes "hi

I would like to retrieve the procedure body(source code) from sql query,

I have search the books online but iam able to get the procedure name using "sp_stored_procedures " but the problem here is i need the procedure body. I think there would be some procedure which will give the source code of the procedure or function or trigger.

If you have any solution for the above problem please mail me ASAP



Regards
Raju"
   

- Advertisement -