Hey Rich, This just sounds like a simple case of trying to get the info on the deadlock. Are you running any transactions on the queries you have? If you need to, run the SQL Trace tool with a flag of 1205, this will give you the necessary info to trace the lock. You also ay want to run an update lock rather than an exclusive lock (as Access does)...that way SQL Server will manage the locking internally on a better scale.
Let me know if you need any more info/sp's on locking and debugging. Neil -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 14:23 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] sql deadlocks Hmm, having some trouble with some forums I've got that are getting busy. Occasionally I'll get deadlock error messages back from odbc about the fact that the process I'm using was chosen as the victim of a deadlock. How can I avoid these? The site is on a fairly cheap shared setup, so can't change the hardware etc.. ------------------------------------------------------- Rich Wild Senior Web Developer ------------------------------------------------------- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. ------------------------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
