Identity Range

From TrialWorks Wiki
Jump to: navigation, search

Identity range issue arise when replication is enabled and too much data has changed since the last sync. If the laptop is available and you perform a synchronization, then the problem will go away. If that’s not the case, then queries can be run to target the affected tables.

exec sp_adjustpublisheridentityrange NULL, 'Contacts'

exec sp_adjustpublisheridentityrange NULL, 'ContactType'

exec sp_adjustpublisheridentityrange NULL, 'CaseContacts'

exec sp_adjustpublisheridentityrange NULL, 'contacttype'

exec sp_adjustpublisheridentityrange NULL, 'Ancillary'