I keep getting a SQL deadlock error which reports my thread as being
deadlocked with another process and chosen as the deadlock victim.
I get this error when I create a loop (1 to 3000) of inserts into a table
based on a particular ID.
Then while this loop is running, I try a select using the same ID. I
intermittently receive this error.
The record I am requesting (and writing) contains a really long text field
(65,000 chars +). Is this the reason I'm getting the error? How can I avoid
this error when my application is 'busy'??
Thanx.
Brook Davies
MaracasMedia.com
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
