Answer Posted / mobin sathupally
Simply execute the sp_who or sp_who2 stored procedure.
In sp_who result set observe the blk column.In sp_who2
result set observe the blkby column.In both result sets we
got spids who blocking the server.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the recovery model? List the types of recovery model available in sql server?
How can a database be repaired?
What is the sql case statement used for? Explain with an example?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is a field name?
Difference between LEN() and DATALENGTH() in sql server ?
How to remove duplicate rows from table?
What is an indexed view?
What is proper subset of candidate key?
How the authentication mode can be changed?
How to create sub reports?
What is the difference between clustered and a non-clustered index?
Do you know what is fill factor and pad index?
What is mscorsvw.exe - process - microsoft .net framework ngen?
What is normalization? Describe its different types.
