I got bcp working!
Here's how:
1. Open SQL Server Configuration Manager and go to the Named Pipe Properties of your instance.
2. Change the value to:
\\.\pipe\sql\query
Note: if your 2000 instance, the old default instance you're replacing, is also using this same named pipe you may need to disable the Protocol for that instance, or maybe even change it.
3. Restart your named instance.
4. bcp works with no server name provided and is talking to the named instance!
bcp "select @@servername" queryout C:\myserver.txt -c -T
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato