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 the sql server 2000 version number?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
In how many ways you can invoke ssrs reports?
What is the difference between drop table and truncate table?
What is the difference between sdf and mdf?
Explain comment on transactions?
what is package and it uses and how can u call a package
What action plan is preferred if sql server is not responding?
What does it mean to invest in the index?
What is a file group?
How do you set a trace flag in sql server?
What is tablix?
What is the concept of optimization?
Tell me what is the stuff and how does it differ from the replace function?
What is the difference between update lock and exclusive lock?
