No need... here's a different twist on that .. make the integer primary key generation setup such that one server has odd IDs and the other even and they each i

No need... here's a different twist on that .. make the integer primary key generation setup such that one server has odd IDs and the other even and they each increment by two. I did this for many years on Sybase and on SQL Server for active-active failover.