What is the command used to check locks in microsoft sql server?
- 1 Answers
- 1138 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rinku Rani
The SP_WHO2 or DBCC INPUTBUFFER command can be used to check locks in Microsoft SQL Server. The SP_WHO2 command displays information about all active processes, including those that hold locks on resources. The DBCC INPUTBUFFER command provides the text of the last executed command by a process holding a lock.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How raid can influence database performance?
When should you use an instead of trigger?
Why we use the openxml clause?
What are the properties of the transaction?
Explain system functions or built-in functions? What are different types of system functions?
What is clustered index
What is sql or structured query language?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is normalization and what are the advantages of it?
Can we do dml on views?
What are the kinds of subquery?
Is it possible to have clustered index on separate drive from original table location?
What is the difference between upgrade and migration in sql server?
How can we solve concurrency problems?
Why use identity in sql server?
