I'm not running transactions no. I'm doing straight inserts and selects from CF.
> 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. How do I do this? > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 17 October 2003 15:06 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] sql deadlocks > > > 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] > -- ** 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]
