一段代码,用于禁止用户登录,执行时报以下错误:
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博客 ” ,链接:http://blog.itpub.net/10640532/viewspace-607656/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10640532/viewspace-607656/