Ad hoc updates to system catalogs are not enabled
一段代码，用于禁止用户登录，执行时报以下错误：
Executed as user: NT AUTHORITY\SYSTEM. Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457) Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this. [SQLSTATE 42000] (Error 259). The step failed.
语句为：
use master
exec sp_configure 'allow updates',1
go
reconfigure with override
begin transaction
update sysxlogins
set xstatus='29'
where xstatus='2'
commit transaction
exec sp_configure 'allow updates',0
go
reconfigure with override
exec sp_configure 'allow updates',1
go
reconfigure with override
begin transaction
update sysxlogins
set xstatus='29'
where xstatus='2'
commit transaction
exec sp_configure 'allow updates',0
go
reconfigure with override
解决方案：
SQLSERVER----properities------server settings-------server behavior-------allow modifications to be made directly to the system catalogs(勾选）
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10640532/viewspace-607656/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
生成创建索引的脚本
下一篇：
和UNDO有关的一些参数
请登录后发表评论
登录
全部评论
最新文章
- ORA-12505: Using Oracle RAC and Java JDBC thin client Connection
- Oracle Database Server 'TNS Listener'远程数据投毒漏洞
- EXP-00106: 数据库链接口令无效
- exp遇到错误ORA-06512 SYS.DBMS_EXPORT_EXTENSION
- DROP USER ORA-00600[16206]
- ORACLE口令文件
- oracle decode用法
- Oracle to_char()
- 切换TEMP表空间遭遇enq: TS - contention
- ORA-01555 on Active Data Guard Standby Database
