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