Hi,

I'm using the function bcp to transfer data from my table to a data file. When I use it at the dos command prompt, no problem everything works really well.

But if I use query analyser I have an error: unable to open bcp host data-file.

Here's the line:
xp_cmdshell 'bcp table.owner.inventaire out c:\1\test.txt'

The problem is not with xp_cmdshell because I can call simpler executables in query analyser.


Thanks again!
-Mic