Monday, March 12, 2012

NFR with merge in em shows weird seed

I've set identity columns to automatic ranges with merge. The publisher
ranges is for a million and the subscriber side is for a million. Now, when I
go to the EM, and go to the Desgin Table in EM for a table, I see the
identity seed to 1. Is this normal? But when I ran the script and everything
and also when I go to the article properties, it shows the correct identity
ranges. Please let me know. thank you very much...
On the publisher this is correct. On the subscriber it should be at
1,000,001.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tejas Parikh" <TejasParikh@.discussions.microsoft.com> wrote in message
news:6B8E4284-B565-4D0C-90E5-5948AA21E136@.microsoft.com...
> I've set identity columns to automatic ranges with merge. The publisher
> ranges is for a million and the subscriber side is for a million. Now,
> when I
> go to the EM, and go to the Desgin Table in EM for a table, I see the
> identity seed to 1. Is this normal? But when I ran the script and
> everything
> and also when I go to the article properties, it shows the correct
> identity
> ranges. Please let me know. thank you very much...

No comments:

Post a Comment