execute sp_who & examine spID & (i guess) the status column from that resultset. find the ones causing you the grief (might need to research this a bit). if its a specific cf username, you can do sp_who @login_name='cfUserName'. then issue KILL #spID# to kill them off. if deadlocks are your problem, use sp_lock....
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.325 / Virus Database: 182 - Release Date: 2/19/2002 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
