错误1：
executing the query “alter index [ix_liveconfigstate_service_serviceid_…” failed with the following error: “the index “ix_liveconfigstate_service_serviceid_grouprightsversion” on table “liveconfigstate_service” 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.
解决方案:
query the indexes and tables list with follow query, then enable their(index) page lock setting from property setting dialog.
select object_name(i.object_id) as tablename ,
name as indexname ,
allow_page_locks
from sys.indexes as i
where allow_page_locks = 0
正常应该只有如下三条记录：
reference page:
http://mr-spapp-01.mr.ericsson.se/sites/mediaroom/productdevelopment/engineering/test/mrscale/_layouts/15/wopiframe2.aspx?sourcedoc=%2fsites%2fmediaroom%2fproductdevelopment%2fengineering%2ftest%2fmrscale%2fshared%20documents%2ftests%2fplans%2finternal%2foob%2fa%2dla%2dcarte%20max%20900%20subgroup%20per%20account%2fa%2dla%2dcartemax900subgroupperaccounttest%2edocx&action=view&wdparaid=2e1e070d