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
Does index speed up select statements?
What do you understand by the analysis services in sql server?
What is delete query?
What is snapshot replication?
Explain what are partitioned views and distributed partitioned views?
How to get the query of a table in sql server?
How to modify an existing user defined function?
What is clustered index
How many clustered indexes there can be on table ?
What is db stored procedure?
What’s the distinction between dropping a info and taking a info offline?
When to use null data driven subscription?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
How to connect sql server management studio express to sql server 2005 express?
How to create user defined functions with parameters?
