Results option for Query Analyzer

• Elliott Berkihiser

  SSCarpal Tunnel

  Points: 4068

  More actions

  January 31, 2007 at 12:02 pm

  #176685

  Anyone know how to specify query results in a file, tab-delimited format in SQL Server 2005?  The menu of Tools/Options does not seem to match what was available to do this in SQL Server 2000.

  TIA,

  Elliott

• lucky-80472

  SSCertifiable

  Points: 7793

  More actions

  January 31, 2007 at 12:10 pm

  #686930

  Hello Elliott,

  You can change the option as follows:

  Go to Tools -> Options

  Under Query Results -> SQL Server -> Results to Text -> Output Format

  Change the default "Comma aligned" to "Tab delimited"

  You need to open a new Query Window.

  Hope this helps you.

  Thanks

   

  
  Lucky

• Elliott Berkihiser

  SSCarpal Tunnel

  Points: 4068

  More actions

  January 31, 2007 at 12:21 pm

  #686935

  Thanks Lucky,

  Don't know how I missed that!

  Elliott