could it be someone was cleaning up data and used a REPLACE without a WHERE statement?
the rowversion gets incrmeneted even thought here was no "real" change:
CREATE TABLE WHATEVER(
WHATEVERID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
DESCRIP VARCHAR(30),
MyRowVersion ROWVERSION
)
INSERT INTO WHATEVER(DESCRIP)
SELECT 'APPLES' UNION
SELECT 'ORANGES' UNION
SELECT 'BANANAS' UNION
SELECT 'GRAPES' UNION
SELECT 'CHERRIES' UNION
SELECT 'KIWI'
--affects ALL rows in the table, but no real change to data, but rowversion is modified.
update whatever set descrip = REPLACE(descrip,'SASQUATCH','')
--vs
--no matching rows, rowversion preserved.
update whatever set descrip = REPLACE(descrip,'SASQUATCH','') WHERE DESCRIP LIKE '%SASQUATCH%'
Lowell