What is MSrepl_tran_version? (MS SQL Server)
what, exactly, is msrepl_tran_version? We have it in all our tables (a rather large number), but I don't believe we're using replication. I guess we did at some point in the past, maybe.


when you have configured Transactional replication with updatable subscriptions, replication adds the column msrepl_tran_version to every table. If the table is dropped from the publication, the msrepl_tran_version column is not removed.

Check with your DBA to see if you still have replication or not.

If you are not using Replication, then to see how this column gets updated, I would suggest you to use profiler.

IF this column is not being used anymore, you should be good to remove/drop it. Refer to my answer with script here.