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 |
|
Mazdak
Yak Posting Veteran
63 Posts |
 Posted - 2003-11-20 : 08:52:24
|
| I want to use bcp command utility to backup a table.I use this command:bcp pubs..mazy out f:\pubs.txt -c -U"sa" -P"sa"but I get this error:SQLState = S1000,NativeError = 0Error = [Microsoft][ODBC SQL Server Driver][SQLserver]Code page 720 is not supported by SQL ServerSQLState = S1000,NativeError = 0Error = [Microsoft][ODBC SQL Servr Driver]Unable to resolve column level collationBCP copy out failedMy collation is Arabic_CI_AS by default. Any idea? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-20 : 12:18:39
|
| Why are you using bcp utility to backup a table? Anyway, remove the double quotes around the userid and password and also provide a server namebcp pubs..mazy out f:\pubs.txt -c -Usa -Psa -Sserver1Tara |
 |
|
|
Mazdak
Yak Posting Veteran
63 Posts |
Posted - 2003-11-21 : 08:54:47
|
Thanks it works now. I want to do it just for learning.  |
|
|
|
|
|
|
bcp Utility