COLLATE的更改

--修改数据库的COLLATE
ALTER DATABASE LNS_Develop2 SET SINGLE_USER WITH ROLLBACK IMMEDIATE
alter database LNS_Develop2 COLLATE Chinese_PRC_CS_AS_WS
ALTER DATABASE LNS_Develop2 SET MULTI_USER
--修改已存在的字段。这段还报“Ad hoc updates to system catalogs are not allowed.”的错误不知道为什么?
--select distinct collationid,collation from syscolumns
EXEC   sp_configure   'allow updates',1 RECONFIGURE   WITH   OVERRIDE 
update syscolumns set collationid =16420,collation='Chinese_PRC_CS_AS_WS' where collationid in (0,16420,4104,65544,53284)
EXEC   sp_configure   'allow updates',0 RECONFIGURE   WITH   OVERRIDE