I see similar things like that happen sometimes and SeeFusion won't kill them either. In those cases, many times what I can do is run an sp_who on the database and look for the offending query, use a dbcc inputbuffer(processid) if need be and then kill that process id. Most of the time, that will allow me to kill the hung thread in SeeFusion so that no restart is needed. I haven't tried FusionReactor so I am not sure it works the same way, but the problem is very similar to what I have seen, just viewed it through SeeFusion instead. I dont know why it happens, something just seems to temporarily have gotten stuck on stupid.
Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
