Could anyone tell me if the following is possible :-
I have a table in one database on SQL server 6.5. I want to copy this table
to another database on another server which is SQL 6. I only want to do
this once so don't want to setup replication or anything like that.
The copy objects program in enterprise manager won't let me select the SQL
6 server as the destination server. So what I really want to know is will I
have to use BCP and dump the data out, copy it across the network and load
it back in? Or is there a way of copying data between databases via ISQL?