sp_helptext popup contents does not contain SPs or views.

stevegsteveg Posts: 9
edited April 1, 2008 2:14PM in SQL Prompt Previous Versions
After typing sp_helptext the popup does not contain stored procs or views, only functions are listed.

Version 3.6.0.109.

(BTW cross-database popups, thank you!)
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Thank you for your post. I have logged this down as a bug in SQL Prompt, to be fixed in a future release. Even in AdventureWorks or northwind, regardless of whether SQL Prompt is used in Query Analyzer or Management Studio, stored procedures and views never show up in the candidate list. Functions and types seem to be available, so it's confusing as to whether this is meant to work, or it works partially 'by accident'. Either way, this support should get fixed or taken out.
    · Share on Twitter
  • shuffshuff Posts: 21
    Brian Donahue wrote:
    Thank you for your post. I have logged this down as a bug in SQL Prompt, to be fixed in a future release. Even in AdventureWorks or northwind, regardless of whether SQL Prompt is used in Query Analyzer or Management Studio, stored procedures and views never show up in the candidate list. Functions and types seem to be available, so it's confusing as to whether this is meant to work, or it works partially 'by accident'. Either way, this support should get fixed or taken out.

    Has this been fixed yet?

    I'm using version 3.7.0.32 and I still get nothing when using sp_helptext.
    · Share on Twitter
  • shuffshuff Posts: 21
    Whats even more annoying is, if I hit CTRL+SPACEBAR after typing sp_helptext I STILL can't select Views of Stored Procedures because they are grayed out from the selection box:

    sqlprompt.jpg
    · Share on Twitter
  • shuffshuff Posts: 21
    11 days and still no response?
    · Share on Twitter
  • tanyatanya Posts: 269
    Hi,

    My sincere apologies for the delayed response.
    We have been looking into this issue and I will update you with the status of this issue shortly.

    Thank you for your patience.

    Regards,
    Tanya
    · Share on Twitter
  • tanyatanya Posts: 269
    Hello,

    This issue is now fixed in our v3.8 that is scheduled for release sometime between mid of April to early May. An early release candidate will be available in the first week of April if you would like to try it :)

    Thanks,
    Tanya
    · Share on Twitter
  • tanyatanya Posts: 269
    Hello,

    v3.8 RC is now available for download.
    http://www.red-gate.com/MessageBoard/vi ... php?t=6760

    Thanks,
    Tanya
    · Share on Twitter
Sign In or Register to comment.