In the trace does the statement complete? If you look at sysprocesses is that spid still running? Are there any object locks that would affect the query?
~Brad -------- Original Message -------- Subject: Re: CF8, Vista, SQL 2005 From: A D <alandeans2...@yahoo.co.uk> Date: Thu, November 19, 2009 2:22 pm To: cf-talk <cf-talk@houseoffusion.com> I ran a trace and the query statement showed up straight away in the trace but CF page just keeps waiting. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4