Sql – How to update a record without changing rowversion


If a table has a rowversion column in it and you make an update to that row, the value of the rowversion column increases. I know that this is by design and the purpose of rowversion columns, however is there any way to make it such that an update operation will have no effect on rowversion value?

Edit: Tracking of updates on all columns is required, however there are some operations that we would like to avoid being perceived as new versions.

Best Solution

No. See MSDN. "Every time that a row with a rowversion column is modified or inserted, the incremented database rowversion value is inserted in the rowversion column."