Improve company productivity with a Business Account.Sign Up

x
?
Solved

where is SQL Server management studio

Posted on 2011-03-20
3
Medium Priority
?
401 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:Murray Brown
3 Comments
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 1000 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 1000 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:Murray Brown
ID: 35175883
Thank you both very much. Great answers
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Understanding the various editions available is vital when you decide to purchase Windows Server 2012. You need to have a basic understanding of the features and limitations in each edition in order to make a well-informed decision that best suits …
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…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

580 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