If identity integer columns cannot be used because of the possibility of the same number being generated by two different servers, why not make the primary key a composite key...