Viewing Stored procedures

[lsgko]

There are some old stored procedures on an SQL 7 server, I need to view the stored procedures to see what commands they are executing. I've looked in the Query Analyzer, Profiler and performance monitor and I can't seem to find it.

How do I view them?

 

[RobertT687]

Assuming you have Enterprise Manager, do this:
In EM expand the object listing for your database.
Select the Stored Procedures tab.
Hilight the stored procedure and double click it.
This brings up the properties window where you can browse the text of the stored procedure.
Or in Query analyzer try: sp_helptext procedurename
Results of the above are not too pretty.

 

[ESquared]

In query analyzer, press F8 to bring up the objects browser. Find the object you want and right-click on it to get scripting options.

-------------------------------------
A sacrifice is harder when no one knows you've made it.