WHICH LOCK to KILL

WHICH LOCK to KILL

 

  

Hi all,

A hypothetical question here, if two users are causing lock problem on
the same row, how do u decide which one to kill or u don't kill but just
ask one of the least priority user to release the lock ...???

Cheers,


EDWIN ONG UY
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous


MS Sql Server LazyDBA home page