I've been working with CF and SQL Server for several years and recently began seeing an error I've never seen before. It occurs very rarely but it's bugging me:
"OLEDB Error Code = 1205 Your transaction (process ID #100) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction." The error is occurring on a pretty simple SELECT query (3 joins) and there is no <CFTRANSACTION> or <CFLOCK> used in the template. I've looked around and can't find anything on this. Has anyone seen this before in this situation? There isn't that much traffic so I don't know what's going on. Thanks, Clark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
