I am using SQL Server 2000 and running number of query simulatneously. While
running update query it is always giving above error. The error discriptions
are -

1. [SQL Server]Transaction (Process ID 52) was deadlocked on {lock}
resources with another process and has been chosen as the deadlock victim

2. SQL Server]Transaction (Process ID 51) was deadlocked on {lock} resources
with another process and has been chosen as the deadlock victim

3. [SQL Server]Transaction (Process ID 56) was deadlocked on {lock}
resources with another process and has been chosen as the deadlock victim


I have tried cleaning up the database, increased the fixed memory size of
SQL Server to 800 MB, restart the machine. But nothing works.

Plz help out to resolve this problem.

get output from

sp_who
sp_who2
sp_lock

when the trans is running

"Sudhanshu" <Sudhanshu@discussions.microsoft.com> wrote in message
news:EBF56A23-2CBC-4E4F-9220-F53C6B656AB1@microsoft.com...
>I am using SQL Server 2000 and running number of query simulatneously.
>While
> running update query it is always giving above error. The error
> discriptions
> are -
>
> 1. [SQL Server]Transaction (Process ID 52) was deadlocked on {lock}
> resources with another process and has been chosen as the deadlock victim
>
> 2. SQL Server]Transaction (Process ID 51) was deadlocked on {lock}
> resources
> with another process and has been chosen as the deadlock victim
>
> 3. [SQL Server]Transaction (Process ID 56) was deadlocked on {lock}
> resources with another process and has been chosen as the deadlock victim
>
>
> I have tried cleaning up the database, increased the fixed memory size of
> SQL Server to 800 MB, restart the machine. But nothing works.
>
> Plz help out to resolve this problem.

Thx. I will check that.

"David J. Cartwright" wrote:

> get output from
>
> sp_who
> sp_who2
> sp_lock
>
> when the trans is running
>
> "Sudhanshu" <Sudhanshu@discussions.microsoft.com> wrote in message
> news:EBF56A23-2CBC-4E4F-9220-F53C6B656AB1@microsoft.com...
> >I am using SQL Server 2000 and running number of query simulatneously.
> >While
> > running update query it is always giving above error. The error
> > discriptions
> > are -
> >
> > 1. [SQL Server]Transaction (Process ID 52) was deadlocked on {lock}
> > resources with another process and has been chosen as the deadlock victim
> >
> > 2. SQL Server]Transaction (Process ID 51) was deadlocked on {lock}
> > resources
> > with another process and has been chosen as the deadlock victim
> >
> > 3. [SQL Server]Transaction (Process ID 56) was deadlocked on {lock}
> > resources with another process and has been chosen as the deadlock victim
> >
> >
> > I have tried cleaning up the database, increased the fixed memory size of
> > SQL Server to 800 MB, restart the machine. But nothing works.
> >
> > Plz help out to resolve this problem.
>
>
>