Hi,
How to Set a Seed Value in SQL Server 2005 for Merge Replciation tables.
I have 3 application and DB servers where in from all the three 3 applications data will be inserted, updated, deleted. Now when i push the 3 db servers into replication, i used the
DBCC CHECKIDENT ( 'TABLE_NAME ', RESEED, 10000000)
for all the tables in the 2nd server, but even after changing the seedvalue to start with the number specified, it has not opted for the number which i have specified but it has taken its own seedvalue, and it is same for the other servers also.
Now My Problem is if wont give the range of seed values in all the subscriber DB servers which is involved in Replication at one point of time we might have a primary key violation problem and it wont allow to insert the records, so please guide me what might be the problem and how to solve the same.
With Regards
dakshina