Hi Diane,

The BCP is external to SQL server utility that can be run from Command Prompt window or batch file.

>Hi everyones,
>
>Using SQL2000, In the query analyser I try this statement which I copied from the help file:
>
>bcp 'SELECT au_frame, au_lname FROM pubs..authors ORDER BY au_lname' queryout Authors.txt -c -usa -pgo
>
>and I get this error: Incorrect syntax near 'queryout'
>
>Any help?
>Does bcp something that must be installed, which doesn't come automatically when installing SQL200?
>
>TIA,
>Diane Robitaille