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

Can you explain different types of joins?

0 Answers  


What is a collation?

0 Answers  


What are the lambda triggers?

0 Answers  


Does a server store data?

0 Answers  


when you create a database how is it stored? : Sql server database administration

0 Answers  






Define compound operators?

0 Answers  


What is the difference between UNION and UNIONALL?

5 Answers   CarrizalSoft Technologies, CTS,


What is the purpose of the model database?

0 Answers  


can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,


What does it mean to be in union?

0 Answers  


how to delete duplicate rows from table

9 Answers   CSC,


What is plan freezing?

0 Answers  


Categories