In oracle look at your alert logs. It will have a file name and a location
if you open this file it gives you details
about what process was/is locked.
In SQL server go to Enterprise Manager click on Management ..Current
Activity..Locks/Process ID
This will give you the who is blocking by holding a lock and who is being
blocked because the lock
is being held.You can click on the blocking lock to see the SQL that is
run and have a choice to kill the
process.
Thank you
Mike Ngong




"Jim Dorame" <[Email Address Removed] 08:48 AM


To: "LazyDBA.com Discussion" <[Email Address Removed] cc:
Subject: RE: List of Activitry


sp_locks

-----Original Message-----
From: Balvinder [mailto:[Email Address Removed] Friday, December 19, 2003 6:33 AM
To: LazyDBA.com Discussion
Subject: List of Activitry


Hi All

Can anybody tell me list of all the activities performed when dead lock
found.

Regards

Banga Balvinder



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page