Microsoft SQL Server Error 5030

来源：互联网发布：生猪体重精确计算法编辑：程序博客网时间：2024/05/22 01:39

在重命名数据库的时候，弹出了错误：

TITLE: Microsoft SQL Server Management Studio
------------------------------
Unable to rename 数据库新名称. (ObjectExplorer)
------------------------------
ADDITIONAL INFORMATION:

Rename failed for Database '数据库原名称'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Rename+Database&LinkId=20476

搜到了如下解决方案：

So, if you are trying to change the collation of a database and getting error 5030, this is much likely because you cannot change the collation of a database when it is in Multi_User mode. In this case, you should try to run the following query.

-- the following line sets the database to "Single User" modeALTER DATABASE DBNAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE-- the following line sets the new collationALTER DATABASE DBNAME COLLATE COLLATIONNAME-- the following line sets the database back to "Multi User" modeALTER DATABASE DBNAME SET MULTI_USER

DBNAME: Database name
COLLATIONNAME: New collation’s name. E.g.: Latin1_General_CI_AI