Although SQL Server implements locking automatically, you can customize locking by using SELECT statement options or by choosing an isolation level with the SET statement. The system administrator can customize locking for all users of SQL Server by setting the lock escalation level.