Tech Talk A software developer on all things tech, and then some


Package ‘Microsoft SQL Managment Studio Package’ failed to load

I had  a fresh Windows 7 operating system, SQL Server install, and had just finished installing SQL Server management Studio(SSMS). I tried running SSMS and got the failed to load error. I had noticed when I was researching this error there were a few solutions besides the one I found, so I thought I'd compile them here.

Solution 1 : Re-installing SQL Server Management Studio

This would make sense to fix any corrupted files that may have been installed during the initial install process. To do this with 08, go to Maintenance -> Repair. Follow the prompts to repair the instance. Also, for other versions, you can use the following

start /wait [Drive of the Media]:\[Location Of The Media]\setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

Solution 2 : Re-installing the Frameworks

Another reason this could have failed is that when I installed one of my frameworks, something was corrupted. To make sure you have the latest, you can find the different versions here:

Solution 3 : The Shortcut Points To The Wrong Path

Sometimes the shortcut on the desktop will point to a shared or network location. Ensure the path is absolute to your SSMS application (c:\Program Files\SQL Server....)

Some more reading and forum posts :

Tagged as: 2 Comments

Installing SQL Server Management Studio (SSMS) for SQL Server 2008

In years past, you could download the SQL Server Management Studio and it was pretty straight forward during the install and you were good to go in minutes. Now they seemed to have made a confusing way to install it which you will spend far too much time trying to figure out. So to save you time, I thought I'd log the steps to speed up the process.


Specify Your Own Select And Edit Top(n) in SQL Server Management Studio

When right clicking a table in SQL Server Management Studio, you have an array of options. Probably the two that I use most however is the "Select Top 1000 Rows" and the "Edit Top 200 Rows". However, sometimes you want to look at a little more than that. I know most of the time I want to select all from a table, not just the top 1000. Well in SQL Server 2008 (might work in older versions as well) you can change the default select and edit numbers.

1) Go to Tools -> Options
2) Select SQL Server Object Explorer
3) You will be prompted with a screen which looks similar to the one below. Edit the "Value for Edit Top <n> Rows command" and the "Value for Select Top <n> Rows" to the desired value. ( 0 will select all)

%d bloggers like this: