• 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


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!