Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a updatable transactional replication set with SQL Server 2008. Everything is working fine.

I added a new table to the existing publication through sp_addarticle followed by sp_addsubscription. After that I ran the Snapshot Agent. The snapshot has been generated only for newly added table. So the new table was successfully replicated to subscriber. I could even able to replicate a newly inserted record into new table to subscriber.

But it's not possible viceversa. When I insert a record into new table in the subscriber database, I am getting an error

Msg 515 'Cannot insert the value NULL into column 'msrepl_tran_version', table Servername.dbo.Tablename'; column does not allow nulls. INSERT fails.'.

Please help me to resolve this issue.

Many thanks in advance.

share|improve this question

That error is telling you that the default value for the msrepl_tran_version table has not been set on the subscriber database (or that you're willingly trying to set the column to NULL in your INSERT statement). It needs to have a default value of newid(). Why that didn't get set though I am unsure.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.