Red Gate forums :: View topic - "sp_helptext" is not generating Stored Procedures names
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt Previous Versions
SQL Prompt Previous Versions forum

"sp_helptext" is not generating Stored Procedures names

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
raghav_khunger



Joined: 28 Jun 2011
Posts: 3

PostPosted: Tue Jun 28, 2011 10:30 am    Post subject: "sp_helptext" is not generating Stored Procedures names Reply with quote

Hi,

I am using SQL Prompt 4.0.2.57 version. I am used to find the scripts of strored procedures via "sp_helptext" command. But writing sp_helptext and then pressing space is not generating the stored procedure names. Is this a known issue or this feature has not been built yet?. I want to tell you the names come when I write "exec" command but not with "sp_helptext" command. It will be good if this feature is taken into consideration. I will be waiting for the response from SQL Prompt team on this.

Thanks,
Raghav Khunger
ASP.NET MVP
http://codeasp.net/
Back to top
View user's profile Send private message
Sian.Williams



Joined: 26 Aug 2010
Posts: 32

PostPosted: Wed Jun 29, 2011 3:49 pm    Post subject: "sp_helptext" is not generating Stored Procedures names Reply with quote

Thanks for your question.

If you go to your SQL Prompt tab within SSMS, click options > types of suggestion and make sure the 'list system objects' box is checked. Then go back to the SQL Prompt tab > Refresh Suggestions.

Now when you type sp_helptext it should give you the same options as EXEC sp_helptext.

I hope this helps.
_________________
--------------------------------------
Siān Williams
Red Gate Software
Tel: 0800 169 7433
sian.williams@red-gate.com
--------------------------------------
Back to top
View user's profile Send private message Send e-mail
raghav_khunger



Joined: 28 Jun 2011
Posts: 3

PostPosted: Wed Jun 29, 2011 5:20 pm    Post subject: Reply with quote

Hi,

I did the same but unfortunately that didn't solve the issue. My "User Defined " stored procedures are not coming.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group