@ken, Thanks for the suggestion of using SEQUENCE but I cant change the object definitions as they are called in numerous places.

@Phil, Its data push rather than push and pull.

@Mister.Magoo, Interesting solution I will look at that in more detail. One thought was also to place the merge on the destination and have a wrapper SP something like.

CREATE PROCEDURE my.Wrapper

AS

EXEC my.Remotesp AT MyLinkedServer

And then change it to a PULL rather than a push.