How can we help you today? How can we help you today?

"sp_helptext" is not generating Stored Procedures names

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
0

Comments

3 comments

Sort by
  • 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.
    Sian.Williams
    0
  • raghav_khunger
    Hi,

    I did the same but unfortunately that didn't solve the issue. My "User Defined " stored procedures are not coming.
    raghav_khunger
    0
  • rlively
    Was this ever fixed?
    rlively
    0

Add comment

Please sign in to leave a comment.