数据库技术:MSSQL数据库buildindex出错

错误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

需要了解更多数据库技术:MSSQL 数据库 buildindex 出错，都可以关注数据库技术分享栏目—编程笔记