"sp_helptext" is not generating Stored Procedures names

[raghav_khunger]

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/

[Sian.Williams]

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
--------------------------------------

[raghav_khunger]

Hi,

I did the same but unfortunately that didn't solve the issue. My "User Defined " stored procedures are not coming.