一篇sql数据库设置的东西

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

 

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/logingyw/archive/2005/04/30/369081.aspx