We had done it for Sybase but I suspect that SQL server has it too. You can turn trace on which will log all transactions. Don't do it in the production environment as it will slow it to a crawl. Check the on line books for more information.
Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm ----- Original Message ----- From: "Dharmesh Goel" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 10:50 AM Subject: OT: SQL statements trap/log for application where source code is not available > Hi All, > > We have an application in VB using SQL server 7.0 as the backend. We want to > find out what SQL statements are run from within this application. Is there > a logging/capturing utility that can capture statements on the database end? > We want to see what happens on the db end when certain actions take place in > the VB app. Knowing this we want to make some admin utilities in CF. > Unfortunately we do not have access to the source code for the VB app. > > Thanks, > > Dharmesh Goel > Programmer Analyst > IT Dept. - Discount Car & Truck Rentals > 416-744-0123 x290 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists