Link to home
Start Free TrialLog in
Avatar of Greens8301
Greens8301

asked on

find who deleted the table in sql server

Found a table empty
None of the daily jobs have caused it

Want to find in any way, from AUDIT database anything about this table , or who deleted it, accessed it etc.

Thanks
Avatar of Daniel Wilson
Daniel Wilson
Flag of United States of America image

If you want to do this in the FUTURE, you canset up triggers to track it.

To find out in the PAST, you need a log analysis tool.  And it will work ONLY if the DB is in Full recovery mode.
Avatar of Greens8301
Greens8301

ASKER

It is in FULL recovery mode.
This tool, is it a built in tool or third party tool

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Daniel Wilson
Daniel Wilson
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I will try this tool

Since I am talking about production database.
I can copy the T-Logs to a development environment and mine the logs in Dev environament, correct ?


Thanks
SQL LOg Rescue will install only on sql server 2000. There is message that it must be manually installed on sql server 2005. Have you ever installed on 2005

Thanks

   
I have not. When I tried it for 2000, their support was good ... I'd ask them.