SQL 2000 Data Transfer is a Snap with SQL 2005 - Oops! there is a problem
(Page 4 of 7 )
Well there was a problem; it is promptly flagged and the processing stops midway. There is a hyperlink to the error message which, when clicked, shows the next screen. You can take a variety of actions, like reading the report, sending an email message, and so forth.

It appears that there already was a table named Customer and this was the reason the transfer of the table did not succeed. Let's start over and get another table, this time named Products, to the SQL 2000 server's database TestRun.

Next: Modifying the transport >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy