- Shared lock is a common lock on every object in SQL Server.
- When you put shared lock on any object/page/extent ..etc, we can perform select operations only.
How to create shared lock on particular object:
select * from dbo.Table_1 with (holdlock) where eno=11
select * from sys.dm_tran_locks where resource_type <> ‘DATABASE’