x

table updated log for 1 crore records

BY mistake somebody has updated tables approx 10000000 records can i know who & when it was updated

more ▼

asked Jul 07 at 01:49 PM in Default

avatar image

vikashrajan
1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jul 10 at 01:27 PM

avatar image

Waqar_lionheart
101 4

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1

asked: Jul 07 at 01:49 PM

Seen: 28 times

Last Updated: Jul 10 at 01:27 PM

Copyright 2017 Redgate Software. Privacy Policy