谢谢,但是刚刚试过没更改成功,错误信息如下: Server: Msg 5030, Level 16, State 2, Line 1The database could not be exclusively locked to perform the operation.Server: Msg 5072, Level 16, State 1, Line 1ALTER DATABASE failed. The default collation of database 'test' cannot be set to Chinese_Taiwan_Stroke_CI_AI.
exec sp_rename N'dd.原名',N'新名',N'column' 更改列名
Server: Msg 5030, Level 16, State 2, Line 1 The database could not be exclusively locked to perform the operation. Server: Msg 5072, Level 16, State 1, Line 1 ALTER DATABASE failed. The default collation of database 'myblog' cannot be set to Chinese_PRC_CI_AS.
重启sql server,然后进入master数据库执行
ALTER DATABASE database_name COLLATE < collation_name > 要执行这个命令最好是只打开一个查询分析器,然后执行 如果打开企业管理器了这个命令也是不成功的
Server: Msg 5030, Level 16, State 2, Line 1The database could not be exclusively locked to perform the operation.Server: Msg 5072, Level 16, State 1, Line 1ALTER DATABASE failed. The default collation of database 'test' cannot be set to Chinese_Taiwan_Stroke_CI_AI.
更改列名
The database could not be exclusively locked to perform the operation.
Server: Msg 5072, Level 16, State 1, Line 1
ALTER DATABASE failed. The default collation of database 'myblog' cannot be set to Chinese_PRC_CI_AS.
要执行这个命令最好是只打开一个查询分析器,然后执行
如果打开企业管理器了这个命令也是不成功的