包养老公,领导班子 小说,张一一博客
错误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:
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
SQL Server免费版的安装以及使用SQL Server Management Studio(SSMS)连接数据库的图文方法
SQL Server 2017 Developer的下载、安装、配置及SSMS的下载安装配置(图文教程详解)
网友评论