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

sql ssms sql-server-2008-express
André Alçada Padez picture André Alçada Padez · Jan 10, 2011 · Viewed 21.6k times · Source

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

Answer

Thomas Rushton picture Thomas Rushton · Feb 10, 2011

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

Related questions

How do I set a column value to NULL in SQL Server Management Studio?

How do I clear the value from a cell and make it NULL?

Read More
Insert Data Into Temp Table with Query

I have an existing query that outputs current data, and I would like to insert it into a Temp table, but am having some issues doing so. Would anybody have some insight on how to do this? Here is an …

Read More
SQL Server 2008: how do I grant privileges to a username?

I need to be able to establish an ODBC connection through SQL Server authentication. In SSMS how do I grant permission for a user to be able to have ALL RIGHTS on a specific database? is there a way to …

Read More