Hi to All,
i'm working on SQL 2005 and C# and in my app ( multithread and
multiprocess ) sometime i have the following error:

System.Data.SqlClient.SqlException: Transaction (Process ID ??) was
deadlocked on lock resources with another process and has been chosen
as the deadlock victim. Rerun the transaction.

Since we are not the DB owners we cannot try to fix the problem on SQL
side so, we would like to be able to catch this kind of exception and
do a retry.

My question is: how can i catch this kind of exception without
searching into the message the string 'deadlock victim'? Does it have
some error number?

Thank you in advance,
Ciao!

Massimo

See this link from BOL:
http://msdn.microsoft.com/en-us/library/ms179296.aspx

--
Ekrem Önsoy



"Massimo" <massimo.frade (AT) tiscali (DOT) it> wrote

On 11 Mar, 15:51, Ekrem Önsoy <ek... (AT) compecta (DOT) com> wrote:
Thank You for your answer but the problem is that we are not working
with SP but with NHibernate. moreover, we are not the DB owners.
What i'd like to know is the specific Exception number, in order to
identify this kind of exception.
Do you know that number or a guide where to retrieve it?
Thanks,
Massimo

I'm afraid you didn't even open that page? Error number for the victim is
1205 as it's stated on that link too.

--
Ekrem Önsoy



"Massimo" <massimo.frade (AT) tiscali (DOT) it> wrote

On 11 Mar, 15:51, Ekrem Önsoy <ek... (AT) compecta (DOT) com> wrote:
Thank You for your answer but the problem is that we are not working
with SP but with NHibernate. moreover, we are not the DB owners.
What i'd like to know is the specific Exception number, in order to
identify this kind of exception.
Do you know that number or a guide where to retrieve it?
Thanks,
Massimo