We recently had an issue where a table powering our website was completely emptied (was ~9600 records, then 0. Table still there) Table emptying happened some time between 02:00 and 06:30 or so Sunday morning (when we first noticed.) It's a strange time for it to happen as there is low load on the site at this time, and developers would not be working on the site at that time (e.g. unlikely a dev typo.) Restored from the 02:00 backup so no permanent damage but I would be keen to try to work out why this happened with a view to it not reoccuring. Can I extract information on what exactly caused this from the transaction logs (e.g. exact time, statements involved, user account involved, anything else?) Would this tool help:http://www.sql-server-performance.com/log_explorer_spotlight.asp - cost $995? Any alternatives costing less?