Thanks for the reply harper, I've now managed to sort this problem out.  Not sure if this is ideal, but what I did was create a windows user on each...

Yes I have already managed to implement a solution whereby 1000000 is added to all the id's from database 1, 2000000 to database 2 etc. but this is not ideal.  However,...

Thanks very much for the help, the id's are not IDENTITY, just integers as far as I can tell.

I have been looking at implementing merge replication as this seems to...