Obviously only if you are using SQL Server.
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Jose Diaz To: CF-Talk Sent: Fri Jun 08 16:59:24 2007 Subject: Re: Finding current queries Seefusion/Fusion Ractor - or you could use query analyzer to sp_lock2 and then dbcc inputbuffer on the spid to see what the sp is that is running. On 6/7/07, Rick Root <[EMAIL PROTECTED]> wrote: > > On 6/7/07, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > >>Depending on your database, just run a query like what I had > suggested. > > > > I don't think this is possible with Access databases. > > If you need to do performance analysis this indepth, you should > definately not be using MS Access! It's a DESKTOP DATABASE! Don't > use it for web apps! > > /rant off > > Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
