Tab Delimited Results From SQL Server

Here is how you can export your SQL Server 2005 Management Studio results to a tab delimited file, including the column names.

Navigate to Tools | Options | Query Results | SQL Server | Results to Text

The settings only apply to new query windows opened.

From
http://www.mssqltips.com/tip.asp?tip=1105