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 disadvantages of indexes?
Does the order of columns in update statements matter?
what protocol both networks use? : Sql server database administration
How will you hide an attribute? : sql server analysis services, ssas
What is TDS(Tabular Data Stream) Gateway?
Write a SQL command to insert and update only a particular field?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What are clustered and non-clustered index?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
Can two different columns be merged into single column? Show practically?
What does null mean?
what is the difference between count(*) and count(1) ?
Difference between uniqe index and uniqe constraint?
What are the lambda triggers?
