SQL Server Performance Forum – Threads Archive

Identity Range error

Hello all, I have received a new error #548 that states: "The identity range managed by replication is full and must be updated by a replication agent. The %ls conflict occurred in database ‘%.*ls’, table ‘%.*ls’%ls%.*ls%ls. Sp_adjustpublisheridentityrange can be called to get a new identity range." I was under the impression that by setting up the Identity field "not for replication" and using the built-in method for handling identity ranges in merge replication, SQL Server would automatically implement this for new identity ranges. This may be my problem; the identity range was set to 100 with a 80% fill rate. The error occurred when my application tried to insert 10,000 records at one time at the publisher. Any thoughts?
Thanks again in advance,
Brian

http://msdn2.microsoft.com/en-us/library/ms152543.aspx
http://www.sqlservercentral.com/columnists/pibison/mergereplicationmanualrangehandling.asp —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

Dinesh
The first link you referred is for SQL 2005 and in SQL 2000 it is bit different as specified in other article. (I don’t think problem is with SQL 2005 replication) Brian
Check these KBAshttp://support.microsoft.com/kb/321879 &http://support.microsoft.com/default.aspx?scid=kb;en-us;830210 also for further information. This linkhttp://www.simple-talk.com/2005/07/05/replication/ explains the scenario with details. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Excellent! After some research the problem was indeed setting a range much lower than needed for one and only one application call to create over 10,000 records at a time… Thanks again!!!
Brian

]]>