Post reply

How to check how many times row in the table has been updated

  • March 12, 2014 at 1:56 am

    #396406

    Hi,

    I want to check how many times the row in the table has been updated

    Is there any predefined function or query to check that (need help ASAP)

    Thanks,

    Sachin Sakpal

  • March 12, 2014 at 2:11 am

    #1696232

    You'll have to implement a custom trigger and an auditing table to track the updates if you want this information. It isn't tracked by default.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 12, 2014 at 2:54 am

    #1696248

    Thanks... 🙂

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply