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

Not working in VS 2005

In Visual Studio 2005 I have added a new textfile to my project and called it SQLxxx.sql. When I CTL + SPACEBAR nothing happens. I do have an open SQL connection in the SQL Server Explorer. How do I use SQL Prompt with Visual Studio 2005?

TIA
tedh
0

Comments

5 comments

Sort by
  • Tilman
    Hi,

    Given that you have enabled Visual Studio 2005 in the options dialog it should just work. Could you tell me a bit about your system? I.e. what's your OS, .NET Framework versions, language/regional settings?

    Regards,

    Tilman
    Tilman
    0
  • tedh
    Hi Tilman,

    Thanks for the reply.

    Visual Studio 2005 is checked in the list of editors in the SQL Prompt options dialog.

    The OS is Windows XP Professional Version 2002 Service Pack 2
    .Net Framework versions v1.0.3705, v1.1.4322 and v2.0.50727
    Language: English (United States)

    Regards

    Ted
    tedh
    0
  • Tilman
    Hi again,

    having put on my thinking cap and carefully rereading your post i remembered a tiny but most important detail. SQL Prompt 2 only works with Database projects. So it's not going to work if you add a text file with an sql extension to any other type of project. Sorry about that.

    Regards,

    Tilman
    Tilman
    0
  • tedh
    Hi Tilman,

    Thanks for the reply.

    This seems like quite a restriction. I am using Visual Studio 2005 Standard version which doesn't provide capability for Database Projects. I am still able to create SQL Queries and Commands through the Server Explorer so SQL Prompt could be of potential use, but as far as I can tell SQL Prompt does not operate at all with the VS 2005 Standard Version.

    If I'm wrong then please let me know.

    Regards
    Ted
    tedh
    0
  • Tilman
    Hi Ted,

    I'm afraid you are right, SQL Prompt 2 only works with database projects in VS 2005 (and 2003).

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.