That means that whatever transaction you were running encountered a database
deadlock. SQL Server decided that the other process was the winner, meaning it
rolled back whatever work your current transaction had done. You'll have to
completely re-run the transaction.
Sorry!
--IronFury
On Tue, 16 April 2002, "Houk, Gary" wrote
>
> First time I've seen this one...what does it mean?
>
> Diagnostics: ODBC Error Code = 40001 (Serialization failure)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID
> 60) was deadlocked on {lock} resources with another process and has been
> chosen as the deadlock victim. Rerun the transaction.
>
> TIA,
>
> - Gary
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
