"sp_helptext" is not generating Stored Procedures names

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

"sp_helptext" is not generating Stored Procedures names

Postby raghav_khunger » Tue Jun 28, 2011 10:30 am

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/
raghav_khunger
 
Posts: 3
Joined: Tue Jun 28, 2011 10:19 am

"sp_helptext" is not generating Stored Procedures names

Postby Sian.Williams » Wed Jun 29, 2011 3:49 pm

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
--------------------------------------
Sian.Williams
 
Posts: 32
Joined: Thu Aug 26, 2010 8:59 pm

Postby raghav_khunger » Wed Jun 29, 2011 5:20 pm

Hi,

I did the same but unfortunately that didn't solve the issue. My "User Defined " stored procedures are not coming.
raghav_khunger
 
Posts: 3
Joined: Tue Jun 28, 2011 10:19 am


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests