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

SQL Prompt Menu in SQL Management Studio

ok, so I have installed version 3, and for the 2nd time in a week, the SQL Prompt menu in SSMS is disabled (greyed out), hence i am unable to access any of the menus/options.

I found another post that mentioned the menu not being available for users other than the one SQL prompt was installed for, but i am the only person that uses this computer, and it was definitely installed logged in as me! That said, the fix from the other post (running some setup file) did fix the problem the first time, but honestly, i dont want to have to do that every couple of days! How about bringing back the menus/options when you right click on the SQL Prompt icon in the task bar?

i am a fan of the program, but v3 seems to have introduced as many issues as it has fixed! Is a bit frustrating!
wilsonbenj
0

Comments

9 comments

Sort by
  • Tilman
    Hi,

    Sorry about the problems you are having. Could you tell me what version of Mangement Studio you are using, and what language it is?

    Regards,

    Tilman
    Tilman
    0
  • wilsonbenj
    Hi,

    I am running Microsoft SQL Server Management Studio 9.00.1399.00 in English (not sure if there is an English (Australian) option, but if there is, that is what it would be!)

    Ben
    wilsonbenj
    0
  • Tilman
    Hi,

    I've added an issue to our system, now. You haven't got our SQL Refector installed by any chance? If so, are you getting the same problem?

    Cheers,

    Tilman
    Tilman
    0
  • wilsonbenj
    nope, i dont have SQL Refactor...i might download the trial and see what happens though!
    wilsonbenj
    0
  • rbjorkquist
    I haven't seen a solution yet and I am having the same. The information I get when clicking the Help | About... is as follows:

    Microsoft SQL Server Management Studio 9.00.2047.00
    Microsoft Analysis Services Client Tools 2005.090.2047.00
    Microsoft Data Access Components (MDAC) 2000.085.1117.00(xpsp_sp2_rtm.040803-2158)
    Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
    Microsoft Internet Explorer 7.0.5730.11
    Microsoft .NET Framework 2.0.50727.42
    Operating System 5.1.2600
    rbjorkquist
    0
  • wilsonbenj
    I have installed SQL Refactor as well now and havent had the problem again yet - but i did have time off over Christmas/New year so it hasnt had much use yet!

    Ben
    wilsonbenj
    0
  • Lionel
    If you try the latest build

    http://www.red-gate.com/MessageBoard/vi ... php?t=4031

    hopefully the menu problems have been fixed. if anyone has still got issues after installing this build please let me know.

    Lionel
    Lionel
    0
  • dougraney
    I can no longer access the SQL prompt menu. I have downloaded the final beta refresh and did a repair. Still not working.

    Microsoft SQL Server Management Studio 9.00.1399.00
    Microsoft Analysis Services Client Tools 2005.090.1399.00
    Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
    Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
    Microsoft Internet Explorer 6.0.2900.2180
    Microsoft .NET Framework 2.0.50727.42
    Operating System 5.1.2600

    Any ideas?
    dougraney
    0
  • Lionel
    It sounds like your version of prompt hasn't been upgraded properly. Could you try uninstalling SQL Prompt rebooting and then installing the beta refresh. That should restore the menu. If that seems like to much work then you can run

    C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe /setup

    which will restore the SQL Prompt menu but will not definatly mean you are running the latest version

    Lionel
    Lionel
    0

Add comment

Please sign in to leave a comment.