SQL Server 2008 R2 - Which Management Studio do I download

Question

I am not sure which of the Management Studio's to download for SQL Server 2008 R2. I see RTM, Express, etc...

Answer 1

Hi Tmg,

You can download SQL Server 2008 R2 Express with Management Tools from this link

http://www.microsoft.com/downloads/en/details.aspx?familyid=56AD557C-03E6-4369-9C1D-E81B33D8026B&displaylang=en

If you want Management Studio alone, you can download from the below link

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

---

Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
If you found this post useful, Please "Mark as Answer" or "Vote as Helpful"

Answer 2

It is available as part of your SQL Server installation software. What are you trying to do? Just install Management Studio on a PC or install the full blown SQL Server on a PC?

---

Jagannathan Santhanam

Answer 3

Hi tmg7156,

 

What's the edition of SQL Server installed on your computer?

 

If it is SQL Server 2008 R2 Express, then you can download the separate SQL Server Management Studio from the link given by Arunraj.C.

 

If you have full version of SQL Server, then you could add SQL Serve Management Studio-Basic or SQL Serve Management Studio-Complete via running the installation media.

 

You may want to refer the below link about difference between SSMS-Basic and SSMS-Complete, so that you could make decision which one is you need to install.
http://blogs.msdn.com/b/psssql/archive/2008/09/02/sql-server-2008-management-tools-basic-vs-complete-explained.aspx

 

Thanks,
Weilin Qiao

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.