Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ASCII Fixed File
- Thread starter Dimitrie1
- Start date
I assume you were saving right from SQL Server Management Studio. If so...
When you right click your result set and click "Save Results As", you can select the type and give it a file name, but...
Take a close look at the save button. There is a little down arrow to the right of the word "Save".
When you click the down arrow, you get a menu with:
Save
Save With Encoding
Click "Save With Encoding"
For Available Encoding, pick ANSI.
-George
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
When you right click your result set and click "Save Results As", you can select the type and give it a file name, but...
Take a close look at the save button. There is a little down arrow to the right of the word "Save".
When you click the down arrow, you get a menu with:
Save
Save With Encoding
Click "Save With Encoding"
For Available Encoding, pick ANSI.
-George
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question