SQL Server Performance Forum – Threads Archive
can’t open stored procedures in Query AnalyzerI’ve connected to a SQl Server 2005 , through a 2000 Query Analyzer. I can see the list of stored procedures , but I can’t actually open them to view. Is this possioble via Query Analyzer? ___________________________________
Need an IT job? –http://www.ITjobfeed.com
You can right-click, Script Object To New Window – As Create (for example) which will show you the create statement of the SP.
Use sp_helptext ‘procname’ Then you can copy paste from the result to the query window. Satya
Yes, it is possible….
Make sure you have sufficient rights…in 2000 you can run sp_helptext against all procedures where in 2005 security got changed…
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.