Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Identity range management

Status
Not open for further replies.

RogueVW

Programmer
Oct 8, 2002
15
US
I have a DB to be used in five locations using merge replication. The identity columns were set as Not for replication.

I would like to set up the Seed and Identity increments like this:
Machine 1 has a seed of 1 and an increment of 2 (odd, positive numbers)
Machine 2 has a seed of 2 and an increment of 2 (even, positive numbers)
Machine 3 has a seed of -1 and an increment of -2 (odd, negative numbers)
Machine 4 has a seed of -2 and an increment of -2 (even, negative numbers)
Machine 5 has a seed of 1,000,001 and an increment of 2 (odd, positive numbers starting at 1 million 1)


The DB already has some data in it.

How do I manage the seed and Increment values.
When I created the publications it wont let me change the table,
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'dbo.tablename' because it is being used for replication.

I can't set up the distributer with the same increment because it needs to change + - for the subscribers.
I can reseed the db with checkident (tablename, reseed, value) but where do you adjust the increment values?

I am a newbie at this and it was put into my hands as I made the original Access DB. so please be gentle.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top