Cannot update Identity Column

Question

I added a article in publication using following script:

USE

            DB   
GO

--Add the new article to the publication
----------------------------------------
sp_addarticle
                @publication = 'publication name'

                ,@source_Owner = 'dbo'
                ,@article = 'table name'
                ,@source_Object = 'table name'
                ,@force_invalidate_snapshot = 1
GO

-------------------------------------------------------
EXEC sp_addsubscription
                @publication = 'publication name'


                ,@article = 'table name'
                ,@subscriber = 'subscriber instance name'
                ,@destination_db = 'subscriber DB name'
                ,@reserved = 'internal'
                ,@sync_type= 'replication support only'
GO

This table exists in subscriber DB.

The tables identity column is marked for not for replication in both Publication and subscription tables.

But i get "Cannot update Identity Column" error.

Any ideas ?

Thanks in Advance.

---

Thank you -Mushtaq

Answer 1

Something is incorrect here. drop the article and re-add it using the @identityrangemanagementoption set to manual for sp_addarticle.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 2

I'm having this issue as well. I'll try the recommended fix, but this seems strange.