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 are the general features of sql server management studio? : sql server management studio
What is side by side migration in sql server?
What is difference between aggregate and analytic function?
How to retrieve error messages using mssql_get_last_message()?
Which language is supported by sql server?
Can binary strings be converted into numeric or float data types?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Explain magic tables in sql server?
Explain data warehousing in sql server?
What is the difference between stored procedure and user defined functions?
How do I delete a sql server database?
Indexes are updated automatically is the full-text index also updated automatically?
Is port 1433 secure?
What is dbcc? Give few examples.
What are the database roles? : sql server security
