• brewmanz (12/22/2014)


    Dan Guzman - Not the MVP (12/19/2014)


    Gaps I don't mind, but really 1000 or 10,000 at a time? It's too much. I guess if you only reboot once a year then it won't matter much

    The 1000/10K/whatever is (IIRC) allocated once PER SUBSCRIPTION, so reboots (of either server or subscribed client) are irrelevant. Once the allocation is half-used, it grabs some more, so you only need to allocate enough to keep it happy between synchs.

    I don't understand your use of the term "SUBSCRIPTION" here. It seems unassociated with the identity increment issue.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service