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

What is sql server used for?

1023

What stored by the msdb?

979

Where are SQL server users names and passwords are stored in sql server?

1240

How to connect of datebase with sql express.?

1085

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

953

What stored by the model?

1032

Why do we use functions?

895

Explain mixed authentication mode of sql server?

1032

Is sql server is free?

952

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

what are the Prerequisites for Replication?

11323

How to rename databases in ms sql server?

1176

What is 2nf in normalization?

972

Can a database be shrunk to 0 bytes, if not, why?

1079

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1084