"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.
>
>