Server Management Studio save as problem 1

[jjefferson]

Until recently I used Query Analyzer to perform ad hoc data extractions, then saving the results in tab-delimited text files.

I've now been converted to SQL Server Management Studio Express (which I like a lot), but the "save results as" function seems to have lost the ability to create tab-delimited files from the results; the only option now seems to be CSV which is problematic to me for a number of reasons.

Have I just missed the necessary settings somewhere, or am I just stuck with CSV if I choose to use this tool?

Thanks!

Jim

 

[RAS56]

I don't know if Express has this but in SQL Server Management Studio, it looks like you can set the output to Tab delimited under Tools | Options | Query Results | SQL Server | Results to Text | Output Format:

 

[jjefferson]

Thanks ras56! That is in the Express version as well. I'm just so accustomed to using results to grid I breezed right by results to text, and it didn't grab me by the collar and slap me around.

Many thanks!

Jim