Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
samrat
Yak Posting Veteran
94 Posts |
 Posted - 2002-02-28 : 05:47:50
|
G'dday Folks..I am trying to find this syetem table MSsub_identity_range. according to microsoft documentation.. it shd be in the subscribers database.. and MSpub_Identity_Range in publisher database.. but i cann't find neither of them.. ..Any suggestion where can i find this mysterious tables.. Cheers,Samrat |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-02-28 : 07:20:31
|
| Might I inquire as to what you are trying to do? Maybe there is another solution if you can't find that table.Michael |
 |
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2002-02-28 : 21:21:06
|
| Michael, i am trying to understand the procedure used by SQL server to issue unique identity range to each subscribers and publisher while using merge replication. As per microsofts documentation, unique block of numbers are assigned to publishers and subscribers. I have a scenario where 1-10 numbers are assigned at publisher and then the blocks of 5 numbers are assigned to subsequent subscribers. So referring back to microsoft documentation in the above scenarioPublisher should get 1-10Subscribers1 should get 11-15Subscribers2 should get 16-20and so on...but in reality when i try and do it... it works out to ..Publisher getting 1-20Subscribers1 get 21-25Subscribers2 get 25-30So what i m trying to figure out is the extra 10 numbers issued by sql server at the publisher. So do you have any idea, why that extra numbers are being allocated at the publisher ???Thanking in anticipationSamrat |
|
|
|
|
|
|
Where can i find...