can't open stored procedures in Query Analyzer | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

can’t open stored procedures in Query Analyzer

I’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? –
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…
Moderator All postings are provided “AS IS” with no warranties for accuracy.