Lost sql prompt as addin to ssms

damcis

My sql prompt is gone from SSMS. Tried to get it back by:
Uninstalled all of sql server management studio and its components. Then uninstalled all of the red gate products (we own sql developers bundle) and then reinstalled SSMS and then redgate and it still does not show.

How can I fix this?

stanori

Hi damcis,

Thanks for your post. We have created a support ticket for you in regards to this issue and will be contacting you shortly.

Best Regards,
Steve

damcis

I was never contacted...

stanori wrote:

Hi damcis,

Thanks for your post. We have created a support ticket for you in regards to this issue and will be contacting you shortly.

Best Regards,
Steve

stanori

Hi damcis,

Sorry that you havent been contacted. It looks like we may have an old email address for you. (I just sent you a Private Msg so we can get a current email address)

In regards to this issue, can you please verify that you are running the latest build of SQL Prompt:

ftp://support.red-gate.com/patches/SQLP ... 3.6.28.zip

Also, we will want to find out what OS and SSMS version you are running.

Thanks,
Steve

randyv

I'm also in a pickle here.

I have SQL Server 2005 EE servers and SQL Server 2008 EE servers.

I installed SQL client for 2008 on my PC and installed SQL Prompt on it.

However, that client gets snarky about opening up the properties on Jobs running on SQL Server 2005 servers.

I got tired of having to deal with it an so I re-installed the SQL Client for 2005.

So, in short, I have both SSMS 2008 and SSMS 2005 running on my PC.
SQL Prompt is still on my toolbar for the SSMS 2008, but not on SSMS 2005.

I have the SQL Prompt license as part of the toolbelt.

So I'm wondering, is this license sufficient to cover both instances of SSMS on my PC. Seems like it should be, but I'm asking because I don't see a way to install it into SSMS 2005.

Thanks in advance for any information you can provide.

Randy Volters

stanori

Hi randyv,

In terms of the licensing you do not need two licenses if you are going to run SQL Prompt in two different versions of SSMS.

Best Regards,
Steve

PDinCA

Hi Randy,

If you're on a dev workstation and have a MSDN subscription, you could get the SQL2008R2 iso and install just the tools.

I've found that SQL 2005, 2008/R2 and 2012 are all tolerated without issue, with SQL Prompt installed, too. All are Enterprise Edition, with a few Standard instances thrown in and a bunch of Express flavors from 2005 and 2008R2.

Hope this helps...

UPDATE:
Dang! First ever issue - right-click Edit Table gives a nasty prefix-suffix error... Try again and the Edit Table window is all grey. At least it works for everything else - so far!

randyv

Steve -

So the next question, how do I install it on SSMS 2005?

Just grab a toolbelt download and install SQL Prompt?

damcis

I'm running latest version of SQL Prompt. I can only tell that by trying to install it again.
SSMS 2008 R2 on Window 7 64bit

Also, it had been working before, but my pc crashed (had to shut it down using the power button cause it wouldn't shut down normally) and it no longer shows in the menu. The tools menu shows sql compare, data compare, data generator, etc. I have completely reinstalled SSMS 2008 R2 and Sql Toolbelt and it didn't help. System restores don't go back far enough to get past the abnormal shutdown. Tried adding keys to the registry and that didn't help either.

-Dan

stanori wrote:

Hi damcis,

Sorry that you havent been contacted. It looks like we may have an old email address for you. (I just sent you a Private Msg so we can get a current email address)

In regards to this issue, can you please verify that you are running the latest build of SQL Prompt:

ftp://support.red-gate.com/patches/SQLP ... 3.6.28.zip

Also, we will want to find out what OS and SSMS version you are running.

Thanks,
Steve