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 |
|
wilang
Starting Member
12 Posts |
 Posted - 2011-01-24 : 03:16:55
|
| Hi all, i have some table. but some day ,the all record in that table has been delete by someone i dont know. I want to trace all query has been run in sql server in few day ago or few hour ago. so i can know what query delele all row in my tables. Can sql server 2000 do that?sorry for my bad englishW |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-01-24 : 09:49:50
|
| Until you run a trace during the deletion or an audit trigger on that table, it is not possible to know who has deleted the data.MadhivananFailing to plan is Planning to fail |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-24 : 16:11:04
|
| If this is something that has already happened, and you did not have a trace running to capture the event then you do not have anything to identify who actually performed the delete.One thing you can do now is review permissions and identify all users that have access to the system and could have performed the delete. Then, you can identify whether or not they need that access and remove it from those who should not have that level of access.Jeff |
|
|
|
wilang
Starting Member
12 Posts |
Posted - 2011-01-26 : 04:23:49
|
| my friend told me it's not possible to trace query has been run in sql server few day ago. thx for all replyW |
|
|
|
|
|
|
How to cek All query has been run in S.Server 2000