MS SQL SERVER 启用对系统目录的特殊更新

--启用对系统目录的特殊更新
USE master
sp_configure 'allow updates',1
GO
RECONFIGURE WITH OVERRIDE
GO

use hyys
select * from sysobjects where xtype='U'
update sysobjects
set name=lower(name)
where xtype='U'

select * from syscolumns where id>10000
update syscolumns
set name=lower(name)
where id>10000

--禁用对系统目录的特殊更新
USE master
GO
sp_configure 'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO