• If you are bcp'ing data out using a query then the syntax is as follows (assuming you want to bcp out all the data in a table):

    bcp "SELECT * FROM database.schema.table" queryout "Filepath" -SServerName -T -c

    I've used BCP a lot lately and I can never remember the syntax so I find this page very useful.

    Regards

    Lempster