Stored Procedure Question.... 3

[pzmgmb]

Does a stored procedure exist that i can type in the name of a stored procedure or a view and it will print out the text of the object. Now when i want the text to a stored procedure i have to open Enterprise Manager and drill down and then copy and paste the text from the object in Query Analyzer.

Isnt there an easier way?

 

[Fuzemmo]

I rarely use Enterprise Manager. Try this. Hit F8 from within Query Analyzer. This will open up the Object Browser. From there, you can right-click on a procedure and choose "edit". This will, I think, accomplish what you are looking for at least to some extent.

 

[JohnDTampaBay]

sp_helptext 'ObjectName'

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[Catadmin]

sp_helpText (procedureName)



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[Catadmin]

Hmm, John and I seem to have replied at the same time. @=)

Gotta love it.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[pzmgmb]

Thanks jaustin4,
I think your tip was for 2000 and i'm in lowly 7.0

JohnDTampaBay and Catadmin thanks for the tip! Starred you both.