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.
+2
A:
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
bobs
2010-10-20 22:33:40
Yes, I think this is what I want. Thanks.
frostred
2010-10-20 22:57:57
Basicaly I want to check if a database has been changed since last time. So I remember the RowVersion value I made a check last time, and compare it with current value.
frostred
2010-10-20 23:00:46
Yep. I think you're on the right track.
bobs
2010-10-20 23:01:35