SQL Prompt 4 and VS 2008

wsorannowsoranno Posts: 65
edited August 26, 2009 8:13AM in SQL Prompt Previous Versions
I installed SQL Prompt 4 and it does not show up in VS 2008.
SQL Prompt 3 was still there , but disabled.
I removed the menu option for SQL Prompt 3 according to a post on this forum and re installed SQL Prompt 4. Still not there.
Is SQL Prompt 4 not supported in VS 2008?
If not I will be going back to SQL Prompt 3.
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

Comments

  • Anu DAnu D Posts: 876 Silver 3
    Thanks for your post and apologies for the inconvenience caused by this issue.

    Answer to your question is Yes, SQL Prompt 4 supports VS 2008. As soon as you install SQL Prompt it gets added in MAnagement studio and Visual Studio.

    Was SQL Prompt added in Management Studio after you installed it?

    Kindly go to Tools > Options > Add-In/Macro Security. Is 'Allow Add-In components to load' ticked?

    If above doesn't help can you try following steps to manually add it in Visual Studio?

    1. In VS 2008 navigate to Tools --> Options --> Enviornment --> Add-in/Macros Security --> Click on 'Add' button and add the link to SQL Prompt (by default it is C:\Program Files\Red Gate\SQL Prompt 4\)

    2. Close Visual studio

    3. Open Visual Studio Command Prompt run command 'devenv /resetsettings' : this will reinitialise the visual studio settings.

    4. Open Visual studio and check if SQL Prompt is added in it or not.

    Kindly let me know whether following above steps resolves your issue or not.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Management studio is fine, just VS 2008 is not.
    I went in and checked the box for it to load.
    When I restarted VS 2008, I get the following error:
    The Add-in 'SQL Prompt 4.0' failed to load or caused an exception.
    Error Message: Unspecified error
    Error number: 80004005
    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
  • Anu DAnu D Posts: 876 Silver 3
    Thanks for your update.

    Can you try following steps:

    1. Remove the SQL Prompt from Tools --> Options --> Enviornment --> Add-in/Macros Security --> Add-in File Paths
    2. MAnually add it as per steps mentioned in my previous steps.

    Kindly let us know if this fixes your issue.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • I removed the path.
    I then added the path.
    Restarted VS 2008.
    No error but no SQL Prompt 4.
    I went in to Add-in Manager and checked the box for it to load.
    Restarted VS 2008.
    Received the same error.

    I am running Vista Enterprise 64 bit.

    Once I ran the devenv /resetsettings
    SQL Prompt 4 is now there.
    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
  • Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post and apologies that the suggestion did not resolved the issue.

    Can you try following steps:

    1. I'd recommend getting the .NET Framework redistributable from Microsoft and reinstalling the 2.0 Framework:
    http://www.microsoft.com/downloads/deta ... layLang=en

    NOTE: Try reopening Visual Studio and Check if error persists. If the error still persists continue ahead.

    2. Open a command prompt, change the directory to the SQL Prompt installation folder. Run
    %SYSTEMROOT%\Microsoft.net\Framework\v2.0.50727\regasm "%ProgramFiles%\Red Gate\SQL Prompt 4\RedGate.SQLPrompt.VSUI.dll"

    3. This will register SQL Prompt as a Visual Studio add-in.

    4. If this is successful, Open Visual Studio Command Prompt run command 'devenv /resetsettings' : this will reinitialise the visual studio settings.

    If the first command returns 'could not find file Extensibility.dll', then Extensibility.dll does not exist in the GAC.

    Download and install the extensibility package from our FTP site:
    ftp://ftp.red-gate.com/development/sqlp ... itymsm.msi
    Then rerun the commands as above.

    If still the error persists Is there anything in the Application Event Log (eventvwr.exe)?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • You must not have read my entire post.

    Once I ran devenv /resetsettings
    SQL Prompt is now there.
    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
  • Anu DAnu D Posts: 876 Silver 3
    phew.....

    I missed such an important point!!

    We are happy your issue is resolved.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.