When a datatype timestamp or rowversion is used, it generates unique value whenever a row is added or updated in a table. It is one of the ways to generate auto-generated values not only for insertion but for updation too. If you want to know the minimum active rowvertion number for a database, you can make use of system function MIN_ACTIVE_ROWVERSION()
The above query returns the minimum rowversion number available for the current database.
Tags: t-sql, sql_server, sqlserver, tsql, timestamp, rowversion,