Run a trace on the DB while you run the query in CF and see if the statement is ever making it to the database. It may be a data source driver issue.
~Brad -------- Original Message -------- Subject: Re: CF8, Vista, SQL 2005 From: A D <alandeans2...@yahoo.co.uk> Date: Thu, November 19, 2009 11:15 am To: cf-talk <cf-talk@houseoffusion.com> No problems in Management Studio. CPU and I/O appear normal. Not sure about the execution plan. Thanks >What happens when you run the query in SQL Server management studio? > >When it hangs what is the CPU and disk I/O doing? >What is the execution plan being used? > >~Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:328519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4