Check out the articles here: http://stackoverflow.com/questions/661908/sql-server-deadlocks-between-select-update-or-multiple-selects
and here: http://blogs.msdn.com/b/bartd/archive/2006/09/25/770928.aspx to troubleshoot and fix different deadlock scenarios. Paul Cormier WebmasteryMadeSimple.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm