How many types of lock exist in Sql server

[Tridip Bhattacharjee]

please provide me good information about various locking mechanism exist in Sql server and when & where which lock is used. thanks

tbhattacharjee

[Lost User]

Tridip Bhattacharjee wrote:

please provide me good information about various locking mechanism

Understanding Locking in SQL Server[^]

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[Corporal Agarn]

Since you did not provide which SQL Server the answer is several. Query BOL and you will find them. You will also need to know the type of resource that is being locked. DATABASE, FILE, OBJECT, PAGE, KEY, EXTENT, RID, APPLICATION, METADATA, HOBT, ALLOCATION_UNIT