Brilliant. Thanks so much. I thought I would have to recreate it. I just saved it down into the project folder and everything was back to working fine!!!!

Thanks again

Matt

Hi. Thanks again for you assistance.

I searched around for a script to automate the reseeding and came across one that checked the identity values. I tweaked it so that...

Hi

Thanks for the great idea. As a variant on that could I replace the 'sycn' with transaction replication between the databases on the same server as well as replicating the...

Hi David,

I really appreciate the time your taking to assist me with this as I am quite new to SQL Server and am still in that space of 'don't know...

Hi David,

Thanks for the reply. I have considered transaction logging but was under the impression that it would not be all that suitable as it is desirable that SQL...