Post reply

how to find a table who have updated and when have updated in a week duration i

  • July 30, 2024 at 10:34 am

    #4440957

    how to find a table who have updated and when have updated in a week duration in sqlserver

    need a user and login details who have done changes in a table and want to see data for last n days

    Thanks
    Naga.Rohitkumar

  • July 30, 2024 at 12:23 pm

    #4440984

    for that you will need to have a audit log table and a trigger on the table you need to monitor- no other way to do it (other then perhaps full C2 auditing) or a extended trace (which you would then also need to parse and load onto its own audit table.

    if that is not already in place you can't get that data.

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

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