No problem 🙂

It may be just a slow connection, and Enterprise Manager is timing out before it is able to complete the registration fully:

Increase your Enterprise Manager's login timeout threshold.

Open Enterprise Manager...

Many thanks Jack,

This would still leave me with either;

3 separate tables being populated by triggers at the source end (with no direct relation to the destination tables)

1 table with fragmented...

You should use DTS during a period of downtime (so that the source DB will not currently be getting updated), and populate the destination tables in the new database with...

Yeah, for some bigger indexes I have got into the routine of setting the DB to simple recovery model, running the reindex, and then reverting to full recovery prior to...

It seems like an authentication/connection issue?

Can you ping the host server?

Can you configure an ODBC connection to the source using the account you're trying to use to register the SQL...

I should also add that there is no timestamp column in the source database so I'm not sure how to go about defining my selection if I did have to...