Post reply

where is sql server management studio

  • December 9, 2010 at 1:04 pm

    #232355

    Hi I successfully installed the following but I don't see sql server management studio for 2008 like in sql server 2005. Where is it? Is it in the Express edition?

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b

    Installation / New SQL Server stand-alone installation or add features to an existing installation

    Thank you

  • December 9, 2010 at 3:31 pm

    #1260822

    the default Express does not include SSMS; you need the "2008 with Advanced Services"

    http://www.microsoft.com/downloads/en/details.aspx?FamilyId=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

    install that, and you'll have the "Express" version of SSMS; it doesn't allow you to open anything but the database engine, even if the server you connect to had, say SSIS, Analysis Services or anything else.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 13, 2011 at 2:00 pm

    #1311300

    Click on Start --> Run: Type SSMS

    if you did install it will open up, or you can get a free version from Microsoft website:

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796]

    QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809

  • April 13, 2011 at 2:05 pm

    #1311307

    note: thread is 4 months old.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply