Skip to content

How to install Microsoft SQL Server Management Studio on desktop

September 15, 2011

A common dilemma is to see that you have MS SQL Server 2008 installed but not the Microsoft SQL Server Management Studio on your PC, to do it go to : –

http://www.microsoft.com/download/en/details.aspx?id=7593

This link installs the Express edition which does essentially everything you need associated with MS Server 2008, as it says its an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server 2008!

sqlserver2008

What I found also is that the installation file wouldn’t install it automatically, you have to select New Install on the SQL Server 2008 Setup, and manually tick the one and only (yes one) shared feature which is Management Tools – Basic to install the Microsoft SQL Server Management Studio on your PC Desktop. Wait for 10 minutes. Voila!

Also if you are programmer, you want to test certain database files for local use in Microsoft Visual Studio 2010, and that means that you want to be able to attach the database on another server (well locally on Visual Studio 2010), then this is what you can do:

  1. Detach the database (right click the database and click Detach)
  2. Copy the mdf and ldf files to your backup location
  3. Attach the database (right click Databases and click Attach)
Advertisements

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: