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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-28 : 06:51:25
|
| Rick writes "Hello,A table was deleted from one of the databases that I use. The contents of the table were deleted- not the table itself. This could have been done with a "delete tablename" query. So I want to see what queries were run. I can't ask the users since this should not of been done. Any method at all is acceptable. I need to find this out as soon as possible. Thank you." |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-28 : 07:18:54
|
| There is no in-build audit trail like that...unless you have made efforts to explicitly keep track of such things.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-28 : 08:26:05
|
| A Log Reader (like Lumicent(SP?)) might enable you to review the transaction log - which in turn might allow you to see when it happened, and what else was going on at the same time, which might lead to diagnosing who/what etc.However, it is better to build auditing in to your application to facilitate this sort of after-the-fact detection, as Harsh described.Kristen |
|
|
|
|
|
|
What Queries was Run?