Posted by Erland Sommarskog on 03/06/07 22:56

(miller.brettm@gmail.com) writes:
> I'm getting the following error message when I try add a row using a
> Stored Procedure.
>
> "The identity range managed by replication is full and must be updated
> by a replication agent".
>
> I read up on the subject and have tried the following solutions
> according to MSDN without any luck.(http://support.Microsoft.com/kb/
> 304706 )
>
> sp_adjustpublisheridentityrange (http://msdn2.microsoft.com/en-us/
> library/aa239401(SQL.80).aspx ) has no effect

You have better luck in microsoft.public.sqlsever.replication. Myself,
I have very little experience of replication.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Delete and update
• Prev in forum: Re: how to recompile / refresh UDFs ?
• Thread view: Re: Identity range managed by replication is full and must be updated by a replication agent. Error Message Makes NO SENSE.

[Reply to this message]