BCP Batch Files

[PETEHO]

I have written some BCP batch files which extract data out of Database. These run fine for me but Ineed people to be able to run these without haveing SQL server installed on their machine. Is this possible

Thanks

Pete Ho

 

[nigelrivett]

bcp is a client utility so has to be installed. It is installed with the client tools so doesn't have to have the server.
It can be run on the server via a query though - as long as the server has access to the directory.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.