Data deleted from table, find out who and how??

I had a few part #'s deleted from an inventory table this
morning that couldn't have been done through the front end
application because my Audit trail doesn't show anything.
Someone deleted these through SQL Ent Mgr. How do I find
out who did it, or any log activity associated with it?
Thanks!

Check out Lumigent's Log Explorer - http://www.lumigent.com.

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
http://www.pinnaclepublishing.com/sql

morning that couldn't have been done through the front end
application because my Audit trail doesn't show anything.
Someone deleted these through SQL Ent Mgr. How do I find
out who did it, or any log activity associated with it?
Thanks!

May also want to look at http://www.lockwoodtech.com to check out their LogNavigator
beta. I think you have to register to try it out, but it's free for now.
Can't say that it's as full-featured as Lumigent, but it may help you.

-Pete

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 24th January 19:24 brandon External User Posts: 1	Data deleted from table, find out who and how?? I had a few part #'s deleted from an inventory table this morning that couldn't have been done through the front end application because my Audit trail doesn't show anything. Someone deleted these through SQL Ent Mgr. How do I find out who did it, or any log activity associated with it? Thanks!

3 24th January 19:24 peter a. schott External User Posts: 1	Data deleted from table, find out who and how?? May also want to look at http://www.lockwoodtech.com to check out their LogNavigator beta. I think you have to register to try it out, but it's free for now. Can't say that it's as full-featured as Lumigent, but it may help you. -Pete