I ran a trace and the query statement showed up straight away in the trace but CF page just keeps waiting.
Thanks >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 > >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:328526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4