Page level locking in SQL Server
Stephen West ~
Modified: March 5th, 2016 ~ ~ 1 Minute Reading
- This topic has 2 replies, 2 voices, and was last updated 8 years, 8 months ago by .
Viewing 3 posts - 1 through 3 (of 3 total)
-
Posts
-
You can enable page level locking with the help of SSMS and TSQL.
1. Go to the Index Properties and select the check box Use page locks when accessing the index as highlighted and then save the changes before rebuilding the index. OR
2. Enable page level locking on index using TSQL commandALTER INDEX <index name> ON <table name> SET (ALLOW_PAGE_LOCKS = ON) GO
Viewing 3 posts - 1 through 3 (of 3 total)
- You must be logged in to reply to this topic.