What are the types of locks available in SQL Server?

There are lots of locks available in SQL Server. Following are the list of most important locks in SQL Server.

  • Shared Locks
  • Exclusive locks
  • Update Locks
  • Intent locks
  • Bulk Update locks
  • Schema locks
  • Key Range locks

Happy Reading :)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.