Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
 Posted - 2008-02-26 : 09:07:55
|
| Hi All,Not sure if this is the right place to ask but..Our company has just migrated to 2005 from 2000. I've got Management Studio doing much of what I need it to do from the old enterprise manager (which I wish I could go back to).My problem is this.When saving CSV files from a script run inside Management Studio (ad hoc reports, custom queries, etc) the default encoding is to UNICODE. This produces files that excel doesn't handle very well (most of the people I'd be sending the results to would freak out when the CSV file doesn't appear as expected).I've discovered that I can change the encoding to ANSI when I save the query but as it's a manual process I'm sure I'm going to get tired of it very quickly. I would really like to make ANSI encoding the default.(at the moment and for the foreseeable future, we don't need the functionality that Unicode provides).Anyone know how to do this -- I've tried searching the docs without success.Thanks All,Charlie.-------------Charlie |
|
|
dpoirier
Starting Member
9 Posts |
Posted - 2009-10-14 : 23:12:19
|
| If you're interested, I created an SSMS 2005/2008 Addin that allows saving SQL query results as an XLS file, with header and value formats intact. You don't have to mess around with importing CSV.http://www.SsmsXlsExport.com/Cheers,David |
 |
|
|
|
|
|
Default Output Encoding for Management Studio 2005