Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

where is SQL Server management studio

Posted on 2011-03-20
3
Medium Priority
?
385 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

885 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