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 are security principals used in sql server 2005?
How to divide query output into multiple groups with the group by clause in ms sql server?
What is abstracting periodical?
What is sql azure database?
Explain transaction server implicit?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Can truncate be rolled back?
How will you hide an attribute? : sql server analysis services, ssas
What happens to a statement batch if there is a compilation error?
Differentiate between sql temp table vs table variable?
How to verify a user name with sqlcmd tool?
where the connection string store in the database
Where can you find the error log information? : sql server database administration
How do I create a trace in sql server?
What’s the distinction between dropping a info and taking a info offline?
