Answer Posted / xavier k.

Solution #1

Simply execute the sp_who2 active and check out the blocked
by column to check the blocked spid and blocked by spid

Solution #2

select * from sys.sysprocesses where blocked <>0

What is database isolation in sql server? : sql server database administration

1025

---

What is a field name?

915

---

Explain the truncate command? : SQL Server Architecture

1094

---

What is acid db?

840

---

How do you start single user mode in clustered installations?

905

---

What is the difference between a view and a stored procedure?

985

---

How to connect Azure federated root database and apply federation in entity framework?

107

---

Can foreign key be duplicate?

1002

---

what is spatial nonclustered index

945

---

How to create a store procedure with encryption?

953

---

What is the use of sql profiler in sql server 2012?

843

---

Does the unique constraint create an index?

991

---

Tell me about builtinadministrator?

947

---

Explain difference between cross join and full outer join?

955

---

How to list all dsn entries on your local machine using odbc_data_source()?

978

---