SQL Server database max row RowVersion

Question

Does anyone know if there is a way I can get a database's max RowVersion value? The database I am using is SQL Server 2008.

Thanks.

Answer 1

Are you looking from @@DBTS, which is the last used value? The variable name still references the deprecated TIMESTAMP (TS part) data type but it's the ROWVERSION last value.

SELECT @@DBTS