SQL Prompt 4 and VS 2008

• 
  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.

  Anu D August 25, 2009 10:02

  - 0 +
• 
  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

  wsoranno August 25, 2009 10:20

  - 0 +
• 
  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.

  Anu D August 25, 2009 10:27

  - 0 +
• 
  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.

  wsoranno August 25, 2009 10:35

  - 0 +
• 
  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)?

  Anu D August 26, 2009 04:41

  - 0 +
• 
  You must not have read my entire post.
  
  Once I ran devenv /resetsettings
  SQL Prompt is now there.

  wsoranno August 26, 2009 08:11

  - 0 +
• 
  phew.....
  
  I missed such an important point!!
  
  We are happy your issue is resolved.

  Anu D August 26, 2009 08:13

  - 0 +

Add comment

Please sign in to leave a comment.