sql server replication: Silly question that came to mind as I was driving back from a poker game:
What would happen if one publication sets an identity range at say, 100,000
and another publication (in the same database) has the identity range set
for 50,000 on the same table?

Hehe. I won... now if I can just cobble together enough wins to get back to
the WSOP this year ...

On a more serious note, I'm in the final stages of rolling out an app and
when the mind is freewheeling, I tend to speculate on what might go wrong
long-term. It seems like some issues of replication could lead to walking
into a dead-end if it were not anticipated early on.

Thanks Paul.



[quoted text, click to view]

Earl,
when you create the second publication, the identity range for the table is
inherited from the first one.
If you're having these sort to thoughts, does it mean you won or lost :)?
Rgds,
Paul Ibison, SQL MVP