SQL query tools

Posted on 2011-04-26
Last Modified: 2012-05-11
I have the SQL server 2005 edition that comes with Visual Studio 2008, so i suppose it's the express edition. I can't seem to find any query tool for this. Can anybody point me in the right direction?? Thanks.
Question by:BobHavertyComh
    LVL 32

    Accepted Solution


    That could be the compact edition.

    You can download management tools from

    Just make sure to instal  the management tools
    LVL 9

    Assisted Solution

    The one you need is SQL MANAGMENT STUDIO EXPRESS.   Thats a free edition
    LVL 9

    Author Comment

    Can this be installed on windows 7 with the IIS enabled or does it have to go on win server 2008?
    LVL 9

    Assisted Solution

    Yes, it can be installed on Win 7 . Just look for the right version for you, I know there is a 32 and a 64 bit edition.

    Good Luck
    LVL 7

    Expert Comment

    Management Studio is the complete tools for sql server.  You can do query, query statistics, query plan, object modification, security, maintenance plan, activity monitoring, schedule job... ...

    but you can also make query inside the visual studio whit the database tools, it's limited in option, but you should be able to accomplish basic query and object modification whiteout problems.

    Open VS 2008
    Go on "View" -> "Server Explorer"
    Add a new data connection to the database
    now you can browse the database and make query

    see attach picture.

    LVL 75

    Expert Comment

    by:Anthony Perkins
    >>Management Studio is the complete tools for sql server.  <<
    The author is using SQL Server Express.  SSMSE does not support "maintenace plans, schedule job"
    LVL 21

    Expert Comment

    by:Alpesh Patel
    Please instal SSMS from Microsoft site.
    LVL 9

    Author Closing Comment

    Thank you.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now