Interested to Buy Any Domain ? << Click Here >> for more details...
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 most common type of join?
Differentiate sql server reporting services vs. Crystal reports?
Can two tables share the same primary key?
Why should one not prefix user stored procedures with ‘sp_’?
If a stored procedure is taking a table data type, how it looks?
What does COMMIT command do?
what are the critical issues you have resloved in your company
What is dynamic cursor in SQL SERVER?
Why we should not use triggers?
What is named query? : sql server analysis services, ssas
Can you pass expressions to function parameters?
What is save transaction and save point?
How to get a list of all tables with "sys.tables" view in ms sql server?
What does Master database contains?
How to find out what is the default collation in a database?
