Thread: Deadlock error when inserting single row

Hi,

I am getting deadlock errors when inserting a single
row into a table. (This being the only statement in
the transaction.) The table has a couple of foreign
key references to other tables. And there are other
more complicated transactions happening in parallel.

Are there any scenarios possible where you might get a
deadlock error when inserting data into a table (with
a single insert statement as the only statement in the
transaction)?

-Anshul

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com