Solved

where is SQL Server management studio

Posted on 2011-03-20
3
374 Views
Last Modified: 2012-05-11
Hi

I have Visual studio 2010 installed on my computer. Do I install

Microsoft® SQL Server® 2008 Management Studio Express

at the link
http://www.microsoft.com/downloads/en/details.aspx?familyid=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en

also I have a 64bit system - do I download the link with 64 in it?
0
Comment
Question by:murbro
3 Comments
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 250 total points
ID: 35175860
>>  where is SQL Server management studio

SSMS does not come with Visual Studio, rather it comes with Sql Server.


>>  Do I install...

You should be able to install it via the link you posted.


>>  do I download the link with 64 in it?

You should be able to use either version if you are in Windows 7. Win7 has an emulation layer for 32-bit apps. I think if you have 64-bit XP, then you *would* need the 64-bit version.
0
 
LVL 6

Assisted Solution

by:AkAlan
AkAlan earned 250 total points
ID: 35175863
Management Studio is part of SQL Server. I believe you have to install it as an add-in so to speak after you install SQL Server. The one you are looking at is SQL Server Management Studio Express. That is the free version and may suit your needs just fine. Do you have SQL Server Express?

If you have a 64 bit machine then yes select the SQLManagementStudio_x64_ENU.exe
This one SQLManagementStudio_x86_ENU.exe is for a 32 bit machine. Ya, not exactly intuitive.
0
 

Author Closing Comment

by:murbro
ID: 35175883
Thank you both very much. Great answers
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Please help with the below query - SQL Server 11 18
Count with a subquery showing details 10 43
Admin account lockout 10 39
Loop through SQL parameters and insert to temp table? 4 38
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question