jk_in_San_Diego (7/25/2013)
Thanks for the reply. I used an SSIS package to output the file as ASCII text to meet my immediate need.I would like to know if it's possible to change a database or table setting (or login setting?) to allow the Results to File query option to send the ASCII text properly rather than defaulting all text output to Unicode text.
Having to write a quicky SSIS package every time I want to generate file output from a table is not a big deal, but it sure seems like a waste.
/john
I digged around for a bit, but could't really find a solutin within SSMS itself.
Like I said, you can quickly convert the file to ASCII with Notepad++. Just a few clicks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP