- Put exclusive (X) lock on any resource like ( page/object/extent .etc) that is exclusive to particular process only.
- Just like a owner of that particular resource.
- we can perform the DML (Insert,Delete, Update) operations automatically to operate on exclusive lock mode.
- How to create or put exclusive lock (X) on particular object.
update dbo.Table_1 set eno=56 where ename=’bujji’
select resource_type,request_mode,resource_description from sys.dm_tran_locks where resource_type <> ‘DATABASE’