Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2006
    Posts
    53

    Unanswered: What to use for SQL queries?

    I frequently need to run ad hoc queries against a database, capturing the output in a text file. In SQL Server 2000 I used Query Analyzer with no problems. In 2005 I'm trying to use the query function in Management Studio-but the output is (so far) unusable due to a Null character (hex 00) that follows every 'real' character. I assume this is due to Unicode but haven't found any way (yet) to tell it to just output in plain everyday text. (ASCII or ANSI-either will work.)

    Is there some other tool I can use for SQL queries?

    Thanks.
    Now back on Oracle. The more things change, the more they stay the same.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    I find SQL Server 2000 Query Analyzer works rather well with SQL 2005, so long as you do not try to use the object browser.

  3. #3
    Join Date
    Mar 2006
    Posts
    53
    Interesting idea-and I still have it installed! Thanks!
    Now back on Oracle. The more things change, the more they stay the same.

  4. #4
    Join Date
    Oct 2006
    Posts
    115
    is SQL 2005 Query Analyzer a seperate product or included in SQL 2000?

  5. #5
    Join Date
    Jan 2007
    Posts
    5
    SQL 2005 (not express edition) comes with SQL Server Management Studio. It includes all necessary functions.
    but in spite of "NULL character" problem it also has some other bugs. Moreover it really heavy and slowly in most cases.
    There are many tools on the market, e.g.
    http://www.sqlmanager.net/en/products/mssql/query
    http://www.toad.com and other

  6. #6
    Join Date
    Oct 2006
    Posts
    115
    yes, I also encountered some bugs, I will compile it and show you guys, see if it's really a bug or my own problem

    however, there should always be work around to tackle this kind of problem

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •