Post reply

Free Query Tool

  • August 18, 2009 at 8:24 am

    #213688

    Could someone recommend a good free query tool? thanks

  • August 18, 2009 at 8:26 am

    #1040918

    Not sure what you mean. Management Studio can be used a query tool, and the Express version is free. Is that what you mean?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • August 18, 2009 at 9:49 am

    #1040985

    sorry for the confusion.

    Management Studio provided the overall server info, we don't want anyone be able to access it. Some persons just need to know the database structure, and be ables to write and execute query, just like query analyzer 2000 provided.

    thanks

  • August 18, 2009 at 9:52 am

    #1040989

    shuzi (8/18/2009)

    sorry for the confusion.

    Management Studio provided the overall server info, we don't want anyone be able to access it. Some persons just need to know the database structure, and be ables to write and execute query, just like query analyzer 2000 provided.

    thanks

    You can use Query Analyzer 2000 to query a SQL 2005 database.

  • August 18, 2009 at 9:56 am

    #1040993

    Or you can set up a group that has the level of access you want, and no more than that, and let them use Management Studio. That's better than hoping that they'll be limited by the tool's shortcomings.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • August 18, 2009 at 12:32 pm

    #1041087

    thank you both

Viewing 6 posts - 1 through 5 (of 5 total)

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