Schema - Locks in SQL Server - Part 7 Tamil
Click here to Subscribe to IT PORT Channel : / @itport28
These locks are acquired on objects (and metadata) level and protecting the metadata.
There are two types of locks available
SCH-S – Schema Stability Lock
Used while generating execution plans. These locks (Shared) don't block access to the object data.
SCH-M – Schema Modification Lock
Used while executing a DDL statement. Blocks access to the object data since its structure is being changed.
Explained in Tamil