Answer / wazid ali

Blocking in SQL Server is a scenario where one connection to
SQL Server locks one or more records, and a second
connection to SQL Server requires a conflicting lock type on
the record or records locked by the first connection. This
causes the second connection to wait until the first
connection releases its locks. By default, a connection will
wait an unlimited amount of time for the blocking lock to go
away.

Answer / shyamsri83

When one transaction is trying to access a record, which is
used by other, then the first transaction has to wait,
untill the second transaction complete. This is called
blocking.

Can primary key be a foreign key?

1 Answers  

---

What is the difference between NOROW and LOCKROW?

1 Answers   Accenture, Honeywell, Satyam,

---

What is a trace frag?

1 Answers  

---

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1 Answers   MCN Solutions,

---

What are the different types of sub-queries?

1 Answers  

---

how to find number of columns in a table in sql server 2000 and 2005 also

7 Answers   HCL, Virtusa,

---

How do I find the query plan in sql server?

1 Answers  

---

what is database replicaion? : Sql server database administration

1 Answers  

---

What is sub query and its properties?

1 Answers  

---

What is transaction server explicit transaction?

1 Answers  

---

Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,

---

what are constraints? : Sql server database administration

1 Answers  

---