SQL - "Save results as CSV" - use comma instead of Semi-Colon

Question

Hey, i need to export a query result to a CSV, but i get a semi-colon as a delimiter.
I went to:

Tools - Options - Query Results - SQL Server - Results to Text

and set

Output format: Custom delimiter  
Custom delimiter: ,

and i still get the semicolon. when i return to the options, the original configuration is set.

I'm using MS SQL Management Studio 2008.

Thanx for the help

Why aren't you using "Output format: Comma delimited"? Does this not appear in Express Edition or something? — Martin Smith, Jan 11 '11 at 00:41

score 26 · Accepted Answer · answered Feb 10 '11 at 10:58

26

This one of the options that needs you to close that query window and open a new one before it takes effect.

answered Feb 10 '11 at 10:58

Thomas Rushton

1 Answers1