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 -------- Original Message -------- Subject: CF8, Vista, SQL 2005 From: A D <[email protected]> Date: Thu, November 19, 2009 10:27 am To: cf-talk <[email protected]> Hi, I have CF8 installed on a Vista laptop using SQL Server 2005. I can connect to the datasource from CF but my queries appear to timeout or hang when using 'SELECT *'. Using 'SELECT colA, colB.....' seems to work. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:328515 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
