不行 执行 alter database pc_plus Collate Chinese_PRC_BIN 失败,提示:
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 'pc_plus' cannot be set to Chinese_PRC_BIN.
按照楼上的方法执行后,出线下面错误 Server: Msg 5075, Level 16, State 1, Line 2
The column 'BMS_ISSUE_AUD.issue_amt' is dependent on database collation.
Server: Msg 5075, Level 16, State 1, Line 2
The column 'BMS_SVC_REQUEST.Amount' is dependent on database collation.
Server: Msg 5075, Level 16, State 1, Line 2
The column 'BMS_ISSUE.issue_amt' is dependent on database collation.
Server: Msg 5075, Level 16, State 1, Line 2
The object 'CK_BMS_ISSUE' is dependent on database collation.
Server: Msg 5075, Level 16, State 1, Line 2
The column 'BMS_ISSUE_SVC_DS.issue_amt' is dependent on database collation.
Server: Msg 5075, Level 16, State 1, Line 2
The column 'BMS_SO_PLAN.remain_qty' is dependent on database collation.
Server: Msg 5072, Level 16, State 1, Line 2
ALTER DATABASE failed. The default collation of database 'db_bms' cannot be set to Chinese_PRC_BIN.