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 > > >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:328517 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
