Deadlock victims

[Jugglering]

I have just noticed this whilst wandering around the sillybank:-

"Microsoft OLE DB Provider for SQL Server error '80004005'
Transaction (Process ID 87) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
/Toolkit/answ.asp, line 1514"

Now, not being a computer programmer, I have no idea what it all means, does anyone else know ?

[ChuckFickens]

two separate processes are trying to lock the same item or resource at the same time for their own exclusive use and neither is gonna back down.

it's normally an indexing problem in the database so any queries thrown at it are being seriously delayed by following redundant links in the index.

Personally though I know Bu@@er all about MS SQL (My database experience is filemaker pro).so have no idea how they'd solve it :)

[squarebear]

It means that two people did exactly the same thing at exactly the same time and you have been chosen (randomly) as the victim. Just do whatever you were doing again, it should be fine.