Interested to Buy Any Domain ? << Click Here >> for more details...
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
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is database white box testing?
What is a filestream?
What is page-level compression?
What is exclusive locks?
What type of locking occurs during the snapshot generation? : sql server replication
What are the filtered indexes?
Determine when to use stored procedure to complete sql server tasks?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is nolock hint in sql server 2008
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Is resultset an interface?
What are rows and columns?
Explain external key management in sql server 2008
what is the information that can be stored inside a bit column? : Sql server database administration
What is an execution plan? When would you use it?
