Hi All, SQL Server locks seem to cause problems that result in processes remaining blocked until something intervenes in two cases: circular dependencies between processes and application or when a query is cancelled but the lock isn't released.
My question pertains to the latter. Has anyone really looked at situations that ColdFusion, through the default JDBC driver to SQL Server 2000 will obtain a table or row level lock and then not release it? Or is this possiblya function of some fault SQL. Or is there some user behaviour that causes the latter to occur? Regards, Dan Baughman ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321623 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4