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 |
|
smousumi
Starting Member
19 Posts |
 Posted - 2004-03-12 : 02:44:06
|
| Hii,I am using Bulk Copy cmd to copy data to text file..but getting syntax error as :"Incorrect syntax near 'queryout'."I query is as below...bcp "SELECT * FROM payroll..EmployeeMaster" queryout Emp.txt -U payroll -P payroll432 -cCan anybody tell me where is the mistake...?mousumi |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-03-12 : 03:06:07
|
| bcp is a command line tool. I think you are trying to run this command from inside Query Analyzer. -ec |
 |
|
|
smousumi
Starting Member
19 Posts |
Posted - 2004-03-12 : 05:03:22
|
| Even i had tried the same in Command prompt, i am getting the error :SQL State=08001 Native Error=17"icrosoft SQL Server does not exists or Access Denied"the username and password i am supplying are correct.....Thanks for helpmousumi |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-12 : 07:30:19
|
| You forgot the -S parameter to indicate which server you want to connect to. |
|
|
|
smousumi
Starting Member
19 Posts |
Posted - 2004-03-12 : 08:00:13
|
| Thanks a lotmousumi |
|
|
|
|
|
|
Error while using BCP command