Data types are not in suggestion list when using VS 2008

wsorannowsoranno Posts: 65
edited September 2, 2009 12:05PM in SQL Prompt Previous Versions
When editing a stored procedure in VS 2008, data types do not show up in the list unless you are connected to the server.
Thanks
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
wsoranno@winona.edu

"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
· Share on Twitter

Comments

  • peter.peartpeter.peart Posts: 364
    Hi Bill,

    Many thanks for your forum post.

    Can you confirm, have you connected to the database and then disconnected previously in that session, or have you not connected at all when you are experiencing this?

    Many thanks!
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
    · Share on Twitter
  • wsorannowsoranno Posts: 65
    I can not, at this time, do anything with SQL Prompt 4.
    I have removed it until the patch release comes out.
    I am using SQL Prompt 3.9.
    Thanks
    Bill Soranno
    MCP, MCTS, MCITP DBA
    Database Administrator
    Winona State University
    Maxwell 143
    wsoranno@winona.edu

    "Quality, like Success, is a Journey, not a Destination" - William Soranno '92
    · Share on Twitter
  • peter.peartpeter.peart Posts: 364
    Hi Bill,

    The latest release of SQL Prompt is available and further information can be found from the below link:

    http://www.red-gate.com/messageboard/vi ... php?t=9517

    Please can you let me know if this resolves your issues Bill?

    Pete
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
    · Share on Twitter
Sign In or Register to comment.