How can you see what type of locks used?



How can you see what type of locks used?..

Answer / ranjit

sp_lock to view type of lock applied

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the differences between having and where clause.

0 Answers  


Explain error and transaction handling in sql server?

0 Answers  


What are sparse columns?

0 Answers  


Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,


When columns are added to existing tables, what do they initially contain?

0 Answers  






How do you delete duplicate records in sql server?

0 Answers  


Difference between Inner vs outer joins?

0 Answers  


Which operator do you use to return all of the rows from one query except rows are returned in a second query?

0 Answers  


ow to bring suspect mode datbase online from scratch

0 Answers  


How to configure odbc dsn with different port numbers?

0 Answers  


What is the minimum recommended amount of ram for sql server 2012 enterprise?

0 Answers  


How do we rollback the table data in SQL Server

3 Answers  


Categories