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 |
|
SBCUser666
Starting Member
2 Posts |
 Posted - 2011-07-18 : 16:43:58
|
| I have a SQL query that returns 1 column. I run it in SQL Server Management Studio 2008R2. I use File\Save Grid Results and create a .TXT file.My problem is the first record of the file has 3 bytes inserted in front of the data. The three bytes are x'EFBBBF'. This causes problems when I use the file in another process.I get the same thing whether I save as .TXT or as .CSV.If I do Query\Results to File I get the same 3 bytes.Any ideas? |
|
|
SBCUser666
Starting Member
2 Posts |
Posted - 2011-07-18 : 17:35:11
|
| Found it. Do Save Results AsEnter file name. Save button now has a dropdown arrow to the right. Click on arrow and select Save with encoding and select ANSI |
 |
|
|
|
|
|
Saving query results