SQL Prompt 4 and VS 2008

wsoranno

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.

Anu D

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.

wsoranno

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

Anu D

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.

wsoranno

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.

Anu D

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)?

wsoranno

You must not have read my entire post.

Once I ran devenv /resetsettings
SQL Prompt is now there.

Anu D

phew.....

I missed such an important point!!

We are happy your issue is resolved.