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
Explain how many normalization forms?
Explain the disadvantages of cursors?
What are exact numeric data types in ms sql server?
What is meant by referential integrity?
What are the types of indexes?
What is an index in sql?
What are the different acid properties?
How to filter out duplications in the returning rows in ms sql server?
What is a transaction and why is it important?
How do I save a stored procedure in sql server?
What are the different types of columns types constraints in the sql server?
How to delete all rows with truncate table statement in ms sql server?
What is the simplest way to create a new database in ms sql server?
What is triggers and its types?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
