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 functions in sql server?
Explain multiserver query
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
mention different types of relationships in the dbms?
Which trace flags are enabled in sql server?
What is the difference between clustered index and primary key?
What are the 2 types of classifications of constraints in the sql server?
A trigger can reference objects outside the current database? State true or false.
What is 3nf normalization?
How to use go command in "sqlcmd"?
Does a specific recovery model need to be used for a replicated database? : sql server replication
What are indexes in ms sql server?
Explain filtered indexes?
Explain about link server in sql server?
What is apply operator in sql?
