Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JaybeeSQL
Posting Yak Master
112 Posts |
 Posted - 2012-06-11 : 09:01:14
|
| Hi all,I need to find out who has been deleting rows out of a database - and if he still is. The Processe Info page doesn't show historical data and the only processes connected into the DB are sleeping. Help appreciated.Cheers,JB |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-06-11 : 10:54:01
|
| Unless you've got some trigger or specific auditing set up - this can be difficult. Some options are: 1) Check the Windows Server Security Logs (assuming Windows logons are being used) 2)Check default trace - this could give you some clues - http://www.sqlserver-dba.com/2012/04/sql-server-default-trace-faq.html3)Is there a log on a Application side?4)Turn on Audit Logon Success ?5)Run a SQL Server Profile TraceJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Who's deleting rows?