您的位置:威尼斯官方网站 > 威尼斯官方网站登录 > 威尼斯官方网站:正规应该只好似下三条记下

威尼斯官方网站:正规应该只好似下三条记下

发布时间:2019-11-20 13:33编辑:威尼斯官方网站登录浏览(112)

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

    正常应该只有如下三条记录:

    威尼斯官方网站 1

     reference page:

    本文由威尼斯官方网站发布于威尼斯官方网站登录,转载请注明出处:威尼斯官方网站:正规应该只好似下三条记下

    关键词:

上一篇:没有了

下一篇:没有了