DevelopMENTAL Madness

Friday, August 15, 2008

Open SQL 2008 Management Studio from Run... command

Since SQL 2005 was first released I have always opened it from the run command in the start menu by typing "sqlwb" after hitting the Windows+R shortcut (Run... command). Why? Because no matter where I am it's the quickest way to open SSMS without using the mouse. Most of the time, because the run window uses autocomplete I only have to type "sq".

So after I installed SQL Server 2008 RTM yesterday (I haven't had any time to mess with the Beta and RC releases because I've been focused on learning ASP.NET MVC, WCF, ExtJs and developing my ExtJs control library as well as a web startup - all in my free time), I started up SSMS '08 and checked my running processes in task manager (CTRL+SHIFT+Esc). What I found is that SSMS '08 is SSMS.exe. So now you can startup SSMS '08 with the following sequence: Windows+R then type ssms, hit enter and it's up and running.

For most of you I'm sure you could have figured this out on your own, but I felt like putting it out there for those who don't. Enjoy!

Thursday, August 14, 2008

SQL 2008 Installation Fails: "Previous Release of Microsoft Visual Studio 2008"

I have been trying since yesterday to install the RTM of SQL 2008. But once I have selected the components to install I get a failure during the check of installation rules. The rule failing is "Previous releases of Microsoft Visual Studio 2008". I have downloaded and installed Visual Studio 2008 SP 1. In fact I've run the install several times.

Then I found this post describing why this error is happening. It turns out I had installed and uninstalled an RC version of 2008 several months ago. But I still had Visual Studio 2008 Shell (integrated mode) installed as well. So I uninstalled this. But after completing the uninstall I was still unable to install SQL 2008.

So I went back to the SP 1 page and noticed there was a separate link for Express Editions of Visual Studio. I remembered I had VC++ 2008 Express installed! After visiting I found this little gem in the page :

IMPORTANT
If you have multiple Visual Studio products installed, you must upgrade all of them to SP1. If you have Visual Studio 2008 and one or more 2008 Express Editions, you cannot upgrade the Express Editions until you have upgraded Visual Studio.

That is the kicker. I had to install SP 1 for VS 2008 first, then ALSO install SP1 for VC++ 2008. This goes for all express editions: Web Developer Express, Visual Basic Express and Visual C# as well as VC++ Express.

I am in the process of installing VC++ 2008 SP 1 (which appears to be a full install), if I run into any other problems I'll update this post. But otherwise, this should correct the issue. Hope it helps!

Labels: ,