[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1703
  • Last Modified:

How to set @identityrangemanagementoption property is "auto".

I have a problem generating a snapshot for merge replication on an SQL Server 2005 database.
The error message is as follows:-

The identity range allocation entry for the Publisher could not be found in the
 system table MSmerge_identity_range.
Ensure that the value for the @identityrangemanagementoption property is "auto".

How do I set the @identityrangemanagementoption property to "auto" ?
0
alcindor
Asked:
alcindor
  • 3
1 Solution
 
RiteshShahCommented:
you can set it from sp_addmergearticle

have a look at following link

http://msdn.microsoft.com/en-us/library/ms174329.aspx
0
 
RiteshShahCommented:
0
 
alcindorAuthor Commented:
Thanks for the information, I adopted another approach because I had 51 articles to set up.
I removed the publisher and he subscriber and then set up the publisher again from scratch and that cured the problem. Prior to that, I inspected the properties of each article that was published and all were set to Automatic in any case so I think we were on the wrong track.
I have awarded the points to you anyway.

Best regards,

Roger
0
 
RiteshShahCommented:
thanks for the points but I guess it is not awarded so far :)
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now