BCP not recognized?

works for me

exec master..xp_cmdshell 'bcp "SELECT * FROM pubs..orders" queryout "c:\FileName.xls" -c'

Password:
NULL
Starting copy...
NULL
6 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.): total 1
NULL


take a look at this (
Denis The SQL Menace
SQL blog:
Personal Blog:

Wow! Same situation: SQL Server reinstalled and incorrect path!

Now, how do I change it???

< M!ke >

according to the person

"Thanks... this indeed worked.

What I found out that due to re-installation of SQL Server, the path
'c:\program files..\binn' has been pushed to the end and it was not appearing
in the xp_cmdshell 'path'.

Once the change was made, I had to reboot the server (just merely
stopping/restarting SQL server didn't help).

It's fine now!!!"

So go to your path and move the 'c:\program files..\binn' to the beginning and restart the server

Denis The SQL Menace
SQL blog:
Personal Blog:

don't know if you know how to do this
Right click my computer from the desktop-->properties-->advanced click on enviroment variables in system variable go to PATH and change it there

Denis The SQL Menace
SQL blog:
Personal Blog:

Sorry - I did read that, but I have no idea what it means. Go to my path where?

< M!ke >

Thank you for reading my mind! ;-)

< M!ke >

in system variable you will see a bunch of variables like PATH, TEMP, TMP, OS etc
copy the text (value) from PATH into notepad, move the SQl server stuff to the beginning paste it back into the value part of PATH,restart the machine and you should be fine

Denis The SQL Menace
SQL blog:
Personal Blog:

Ok I see you got it

Denis The SQL Menace
SQL blog:
Personal Blog: