SQL Default lock mode

SQL Default lock mode

SQL

SQL Default lock mode

Download (.zip)

USE PUBS
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
BEGIN TRAN
SELECT * FROM authors
WHERE au_lname = 'Ringer'
EXEC sp_lock2 @@spid
COMMIT TRAN

SQLDefault lock mode Locks for table creation Repeatable read mode
SQLrow locks serializable mode sp_blockinglocks
SQLsp_leadblocker sp_lock2 Update in serializable mode no index
SQLUpdate in serializable mode with index Update locks