question

vikashrajan avatar image
vikashrajan asked

table updated log for 1 crore records

**BY mistake somebody has updated tables approx 10000000 records can i know who & when it was updated**
update_query
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Waqar_lionheart avatar image
Waqar_lionheart answered
If your database has full recovery then you can potentially interrogate by looking at the log. You can also check if you have a trace running or an audit set up. Gotta know what your configurations are.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.