<\/p>\n
“Executing the query “ALTER INDEX [index_name] ON [dbo].[table_name] REORGANIZE WITH ( LOB_COMPACTION = ON ) ” failed with the following error: “The index “index_name” (partition 1) on table “table_name” cannot be reorganized because page level locking is disabled.”. Possible failure reasons: Problems with the query, “ResultSet” property not set correctly, parameters not set correctly, or connection not established correctly.”<\/p>\n
You may encounter an error message when you reorganize an Index.<\/p>\n
The reason you are getting this error is that the ALLOW_PAGE_LOCKS property of the corresponding Index is turned off.<\/p>\n
You can run the following query to see the indexes with ALLOW_PAGE_LOCKS turned off in your database:<\/p>\n
SELECT A.Name AS InName,ob.Name AS DBName FROM sys.indexes A \r\nLEFT OUTER JOIN sys.objects ob ON ob.object_id = A.object_id \r\nWHERE ALLOW_PAGE_LOCKS = 0 AND ob.type = 'U'<\/pre>\nYou can enable the ALLOW_PAGE_LOCKS property of an Index with SSMS or with T-SQL:<\/p>\n
With SSMS:<\/strong> Right-click on the Index in the table, select “Properties” from the drop-down menu and select “Use page locks when accessing the index” in the Options section of the pop-up window and click OK.<\/p>\n
With T-SQL:<\/strong> Run the following command for the corresponding index:<\/p>\n
ALTER INDEX\u00a0 index_name ON table_name SET (ALLOW_PAGE_LOCKS = ON)<\/pre>\n\n<\/div>\n