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 |
Post New Answer View All Answers
What is read committed?
Do you know spatial data types - geometry and geography in sql server 2008?
What is a primary index?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What are temporal tables in sql server 2016?
Explain external key management in sql server 2008
Can truncate be rolled back?
How to select all columns of all rows from a table with a select statement in ms sql server?
What are the 2 types of classifications of constraints in the sql server?
How to identify current user in ssrs report?
What is an expensive query?
What is difference between primary key and foreign key?
How do I install only the client tools of sql server 2000?
how to do partition in sqlserver
What is lookup override?