Home Forums SQL Server 2005 Administering How to change default format from unicode to ANSI for query outputs in SQL 2005? RE: How to change default format from unicode to ANSI for query outputs in SQL 2005?

  • KennyClarck (1/10/2008)


    Which tools you use to create your file?

    It's just a simple query (new query from SQL management interface).

    I have created a table on the other server that contains all the info I need (and only the info that I need), so it's a SELECT * FROM tablename

    And I have the results go to a file. That file *always* gets the UNICODE format. I can't seem to change that, no matter what I select.

    Thanks.