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 |
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-05-25 : 09:06:10
|
How can I find Who (user id) delete records last week /last month?in sql databases?is there any third party? or from sql server 2008 MSSM .Thank you |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-05-25 : 09:22:28
|
I don't think you can, unless you had set up some type of audit or trace beforehand. There is none that is set up by default. |
|
|
jfarrugia
Yak Posting Veteran
55 Posts |
Posted - 2011-05-26 : 04:21:24
|
deletes at times can be found in sql server logs if enabled.. truncates will NOT.Where software development knowledge meets the reader |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-05-26 : 04:51:57
|
you need to create a trigger to audit DML operations for that... |
|
|
|
|
|