Using SQL Server Snapshot Isolation is it possible to determine a row being read is not the latest?
As far as I know there is no way to do this, you can see how many rows are in tempdb using a query like the below
SELECT  version_ghost_record_count
  FROM  sys.dm_db_index_physical_stats
    (
        DB_ID(),
        OBJECT_ID(N'dbo.sometable', N'U'),
        1,
        NULL,
        N'DETAILED'
    )
  WHERE index_level = 0

but this will only tell you at a table level (or partition if you are using those) &amp; you want to get down to row level, more info here :-
https://www.red-gate.com/simple-talk/sql/performance/read-committed-snapshot-isolation-high-version_ghost_record_count/