There's a bunch of transaction log analysis tools out there. We use Redgate's SQL Log Rescue.
On a busy site the transaction logs are voluminous and take a long time to analyze. Depending on your situation you may actually be better off analyzing the injected queries, perhaps running them on a test server. Jaime > -----Original Message----- > From: jonese [mailto:[EMAIL PROTECTED] > Sent: Saturday, 9 August 2008 12:32 AM > To: CF-Talk > Subject: Way to View SQL Transaction history.. RE SQL Injection > > Hey all, > > So far we've been good but i'm helping some other companies > who have experience successful SQL injection attacks. > > Is there any way to see the log files of every transaction > for a DB so we can see which queries failed and which ones > were a success? > > jonese > http://www.jonese.us > http://twitter.com/jonese > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310778 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4