In SQL Server 2005, 2008, 2008 R2,... Select Session_ID, Blocking

how to know Who Is Blocking Your SQL Server?

Question Posted / pandians

Answer Posted / pandians

In SQL Server 2005, 2008, 2008 R2,...

Select Session_ID, Blocking_Session_ID From
Sys.Dm_Os_Waiting_Tasks Where Blocking_Session_ID Is Not
Null

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain how dts is used to extract, transform and consolidate data?

937

Which are the olap features?

907

Explain error and transaction handling in sql server?

953

Explain about Joins?

934

What is wide table?

885

What is partition index in sql server?

1046

Difference between group by clause and having clause in SQL?

925

Difference between primary key and clustered index?

932

What is key set driven?

893

What is data set in report?

121

Can binary strings be used in arithmetical operations?

882

How to list all objects in a given schema?

984

Give me any three differences between Truncate and Delete.

1040

How do I partition a table in sql server?

984

Do you know what are various aggregate functions that are available?

1015