Deadlock is a bassically a name of setuation, when two processes are reqest to the one lock of the one piece of data, attempt to acquire a lock on the other's piece. so ofcouse Each process would wait dor the realease the lock, unless one of the user processes is terminated. SQL Server detects deadlocks and terminates one user's process.
