TheSQLGuru
3/19/2007 11:27:00 PM
Locking: sql server internal mechanism for saying "I got this and you may
(or may not) play with it"
Blocking: the guy (spid) who wants to play with something exclusively locked
is blocked
Deadlock: spid 11 has a lock on resource A1 and wants to get a lock on
resource B1. spid 22 has a lock on resource B1 and wants to get a lock on
resource A1. They will sit there, holding their lock and waiting for the
other thing to be granted to them, indefinitely
--
TheSQLGuru
President
Indicium Resources, Inc.
"FARRUKH" <farrscorpio77@hotmail.com> wrote in message
news:6D13A78C-FDBF-4B57-9075-9635D839C105@microsoft.com...
> whats the difference between deadlock, locking and blocking
>
> thanks