question

Newbie Bala avatar image
Newbie Bala asked

Identity Range Issue in SQL Server 2000.

We receive an error **"The identity range managed by replication is full and must be updated by a replication agent."** While searching that particular table's Identity Constraint in the Publisher Server it shows as 4000 to 6000 but when we search the range by using the table "**MSrepl_identity_range**" it shows incorrect range (2000 t0 2147483647) of Identity in the Publisher Server. I am newbie to this. Please give me any suggestions.
sql-server-2000merge-replication
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Usman Butt avatar image
Usman Butt answered
Are you running your instance with latest Service Pack? If not then this [KB][1] would tell you the reason and workaround. Moreover, these KBs would be helpful in either case. http://support.microsoft.com/kb/304706 http://support.microsoft.com/kb/322910 [1]: http://support.microsoft.com/kb/321879
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.