Locking in SQL Server 6.5

(Alexander Chigrik) In this article, I want to tell you about general details of SQL Server 6.5 locking, about Transaction Isolation Level, what kind of Transaction Isolation Level exists, and how you can set the appropriate Transaction Isolation Level, about Lock types and Locking optimizer hints, about Lock Escalation, about Deadlocks, about how you can view locks with sp_lock stored procedure, and how you can set insert row lock for a particular table or tables.