Solved

How to set @identityrangemanagementoption property is "auto".

Posted on 2009-07-10
4
1,539 Views
Last Modified: 2012-05-07
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
Comment
Question by:alcindor
  • 3
4 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24821644
you can set it from sp_addmergearticle

have a look at following link

http://msdn.microsoft.com/en-us/library/ms174329.aspx
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24821651
0
 
LVL 2

Author Comment

by:alcindor
ID: 24824099
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
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
ID: 24828518
thanks for the points but I guess it is not awarded so far :)
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now