This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
How to check sys.dm_tran_version_store how to check which row from the table the records are originate from which row from the original table ? and from which transaction ?
What is your actual use case? The documentation in Books Online gives some indication of how you would go about, but you will need to do a lot of bit fiddling to identify where the key values are located. Not talking about how to determining the table.
what do you mean ? please show me the steps instead of just direct me to "Books Online" , which book? which page ?
No, I am not going to show you the steps, because you are asking for something advanced that I don't know the solution on the top of my head myself. I would have to spend a full day or so to figure this out. And frankly, I don't feel like to doing that. Least of all when I don't know why you are asking this question.
The page to look at is of course the page for sys.dm_tran_version_store.
Books Online is simply the name for the SQL Server documentation.
Hi @sakuraime ，
Please check if below link could help you.
Version Store: logical structure
Best regards,
Cathy Ji
ok. it's showing from which database (database ID). however don't know originate from which table ? or which running session ?