What do you mean by Deadlock?

What do you mean by Deadlock?

Deadlock is a basically a name of situation, when two processes are request to the one lock of the one piece of data, attempt to acquire a lock on the others piece. so ofcouse Each process  would wait dor the release the lock, unless one of the user processes is terminated. SQL Server detects deadlocks and terminates one user\'s process.

By:UMANG
Date:2013-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher