How can you see what type of locks used?

Answer Posted / ranjit

sp_lock to view type of lock applied

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is normalization? Explain different forms of normalization?

534


explain the storage models of olap? : Sql server database administration

518


What is multi-statement table-value user-defined function?

534


Explain view in sql server?

619


What are the difference between primary key and unique key? : sql server database administration

523






What is a covered index?

518


What is the difference between varchar and varchar types?

562


What are .mdf files?

518


What is data file in computer?

539


How except clause is differs from not in clause?

534


What are the underflow and overflow behaviors on float literals?

572


How you can get a list of all the table constraints in a database?

511


How and why use sql server?

539


What is user-defined function?

565


What is use of attributehierarchyenabled? : sql server analysis services, ssas

605