How to find who ran the update |Delete sql command in MS SQL 2012

Question

I need to find if there is any query to find out who ran delete or update sql command in MS SQL 2012.

Thanks, Bharat

score 0 · Answer 1 · edited May 23 '17 at 12:29

0

Unless you have audit running, it might be hard to tell.

If you are looking for something that happened recently, it might be in the plan table ...

edited May 23 '17 at 12:29

Community

answered Jul 21 '15 at 16:21

citywall

How to enable auditing for specific to update and delete things. – bharat chand Jul 21 '15 at 16:46
google it, try it out and then come back with any questions :) – citywall Jul 21 '15 at 16:57

score 0 · Answer 2 · edited May 23 '17 at 12:14

0

You could use CDC with small adjustments to monitor who made changes in your data.

edited May 23 '17 at 12:14

Community

answered Jul 21 '15 at 16:38

Stepan Novikov

2 Answers2