Tuesday 8 June 2010

sql server 2008 EXPRESS with Management Studio

SQL Server 2008 Express is available to download for free from Microsoft.
The basic installation file does not install the management studio.

There is a version of Management Studio for Express which is also free, this is a separate download.

When installing the management studio, there is a gotcha to beware of.
You are given the choice of 1) adding to an existing instance, or 2) installing a new instance. It would appear that 1 is the correct choice, but in fact it is 2.