Application of Triggers and Understanding the Transaction Procedures in Database Part – 7 How to Control SQL Server Locks? The different types of locks are applied spontaneously by the SQL Server only. By default, the SQL Server locks every single row / tuple which an individual request. At times when an individual request a huge result set, the locks can…