SQL Server Performance Forum – Threads Archive

sp_adjustpublisheridentityrange – Does not work

Hi There Here is a litte hint to solve a replication problem. I had for some time problems with users, mixing some records together becasue user A creates a record on the Publisher, and user B creates another one on a Subscription database. Then I find out how to use "Identity Range" in the table properties when creating the publication, and the first time it works very fine. GREAT. [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] Then I had to recreate the publication again, an suddently the Subscription databases gets an error says "Your table identity interval is full – use sp_adjustpublisheridentityrange to get a new interval from replication agent" Unfortunatelly this does now work either on the publisher nor on the subscriber. I recrated the Publication several times but the same error every time. Suddently I found out that somehow the replication has automaticaly created a "Check Constraints" on the table called repl_identity_range_pub_xx the first time, but have not deleted it again. The Identity interval was not the same second time I created as it was the first time, and then it was imposible to add new records on the subscriber database. Deleting this Check Constraint – solve the problem. Yes..yes..yes…. This was just another hurtle on the daily DBA life. Take care out there. Best regards Jan Borup Coyle btw. Does anyone know how to save a Publication configuration, so recreation of a Publication not should take so long time, when it’s not all Tables, SPs, Views ect. there should be in the Publicataion.?

]]>