Cool. Especially the way to automate BCP. Very useful as a backup tool.
However, I have a problem with this bcp feature itself : I have a database which holds many French words, spelled with the nice é, è, ê, û aso characters.
When I bcp them out, and then re-bcp them in, they are converted to silly other things , due to the non-unicode-compliance of wordpad flat text documents . Any idea how I could conserve the code page stored in nvarchar fields, in a bcp file?
Maybe, a pro like you guys knows an answer here ?