Thanks to all.

Transactional replication it will be.

I suppose it best I keep quiet about our 6.5 Production databases then!!!

Thanks Michael.

Looks very interesting however our Production database is SQL Server 2000 with no signs of upgrading!

Sorry, should have mentioned it before.

Could I upgrade to 2005 and run it in...

Hi Adi,

Thanks for the reply.

We have considered replication, but it seems a bit overkill for 4 fields in one table.

But ultimately, it may have to be the replication way.

M.