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
How to declare a cursor with "declare ... Cursor" in ms sql server?
What is sharding?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Why use view instead of a table?
List some of the rules that apply to creating and using a ‘view’
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is store procedure? How do they work?
What part does database design plays a role in performance of an sql server-based application?
What are the diifferences between the ms sql server vs mysql?
what are the three command line utilities and what are their primary functions?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
Differentiate between delete and truncate.
What is the index requirement in SQL Azure?
What are the recovery models for a database?
