Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to know Who Is Blocking Your SQL Server?

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


Please Help Members By Posting Answers For Below Questions

What is read committed?

1084


Do you know spatial data types - geometry and geography in sql server 2008?

1033


What is a primary index?

921


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

1041


What are temporal tables in sql server 2016?

883


Explain external key management in sql server 2008

887


Can truncate be rolled back?

937


How to select all columns of all rows from a table with a select statement in ms sql server?

1114


What are the 2 types of classifications of constraints in the sql server?

1120


How to identify current user in ssrs report?

401


What is an expensive query?

927


What is difference between primary key and foreign key?

900


How do I install only the client tools of sql server 2000?

1067


how to do partition in sqlserver

2470


What is lookup override?

1024