Any way to automate those 2 steps? And where are the DTS options in 2005?

Thanks for your help, again as already mentioned in the original post when I try and use the copy wizard it fails because it tries to list the available databases...

As already mentioned the import wizard *appears* to only allow me to import tables & views.

Hi - Due to the fact that it is hosted I do not have access to do either of those things.

That worked perfectly - thanks

Hi - can I ask if you have actually tried this? Because its not working for me.

I'm putting the following in my Server Name box

http://www.mysqldomain.co.uk, MySqlPortNo

Because its the default...

Slow oh its slow....

I had to extend the timeout period for any connection to a remote server! And anytime I try and load an object (sp, view) from a remote...

I think thats probably overkill - there are many many situations when triggers provide a very good solution - one does need to be careful with trigger design however. Also...

Well it seemed that it was a naming problem...

alter table dbo.MyTable enable trigger MyTableTrigger

works

Arr yes... there is a reason for that.

Tables that reference a contact e.g. document have a link to client and a link to nurse, making the primary key on Contact...

Probably because all the ids are GUIDs

Neat trick... unfortunately ordering this view slowed it down again

Cool, that gave me a 25% improvement

Apart from the fact that SQL Server doesn't actually allow the 'order by' clause in views...

Very very true... excellent reasoning... now I just have to work out why the same row is being locked from both processes - because it very uncommon with this system...