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 |
rolandsantos
Starting Member
24 Posts |
Posted - 2008-03-10 : 02:59:22
|
guys, how can i list the users who accessed a database for the last 2 days? or users who deleted records on a table for the last 2 dyas?thanks in advance |
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-03-10 : 07:25:55
|
not unless you had profiler running for the past 2 days tracing all SQL statements.oryour code, self-logs who is running each step....andnot unless you have triggers on the tables re the 2nd question |
|
|
rolandsantos
Starting Member
24 Posts |
Posted - 2008-03-10 : 20:58:43
|
No i don't have a profiler or trace running. Also, my audit logs is selected to "none". I just thought maybe that there is any way or trick to list users who logs or what commands they executed for a specific period of time. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-10 : 22:24:48
|
You need auditing tool running to know who used table. For deleting history, try Lumigent's Log Explorer. |
|
|
|
|
|