Hello SQL DBAs,

I needed little more clear information on this column: 'Msrepl_Tran_Version'.

I configured the 'Transactional Publication with Updatable Subscriptions'. I created the DB: "sourav" and included only one article(table):' tab_pk'. I inserted 7 records there. Now, after the replication was setup I found one more Column i.e, "msrepl_tran_version" was added to it.

After the snapshot executed I found that those 7 records successfully replicated to the subscriber. Now I wanted to add some more rows to the "publication DB" Table: 'tab_pk'.

insert into tab_pk values('sachin',default)

But, I'm getting the below error msg:

"

Msg 213, Level 16, State 1, Line 1

Insert Error: Column name or number of supplied values does not match table definition.

"

The table had 4 columns:

id: Identity

name: Char

Address: Varchar default (Bangalore).

Check the 2 attachments for more details.

Suggest me, how can I insert records to the "publication table" so that those new details can be replicated to the Subscriber end??