whats with MSrepl_tran_version column added to sub/pub

[miq]

Hie,
I implemented replication in test environment. Replication added column named "msrepl_tran_version" to publicatin table as well as subscription table.
Now i have uninstalled replication services (i.e. removed publisher/distributor/subscriber but still these columns exist in both tabes (publication as well as subscription table). How can i remove these columns.
I believe this should be done automatically by sql server when replcation is removed. Is this an unexpected behaviour or a norm one. Do we have any SP or something like that or I have to remove it manually using alter table.
Also, when i implemented replication next time on same severs with same roles previously configured transactionl distribution jobs were present (not functional though). It looks as if replication is not remove/disabled completely.

How can you help me i this regard?

BYe
miq

 

[miq]

well,

Ok. I figured it out myself. Its a column
created by sqlserver itself for replcation trascations tracking.

And, by the way, I used sp_subscription_clean SP to remove
previously deleted subscription whcih were still showing at subscriber but after executing SP everything get sattled.

I hope this informatin may come handy to someone out there

Bye
miq