Microsoft SQL Server Error 5030（转）

最新推荐文章于 2022-05-10 10:04:58 发布

转载最新推荐文章于 2022-05-10 10:04:58 发布 · 212 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/defoliation-love/archive/2011/04/13/2014854.html

文章标签：

#数据库

本文介绍了解决Microsoft SQL Server中遇到的错误5030的方法。当尝试更改数据库排序规则时出现此错误，因为数据库处于多用户模式。文章提供了一组SQL命令来解决该问题：首先将数据库设置为单用户模式，然后更改排序规则，最后再恢复为多用户模式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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" mode 

ALTER DATABASE DBNAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE

 -- the following line sets the new collation 

ALTER DATABASE DBNAME COLLATE COLLATIONNAME

 -- the following line sets the database back to "Multi User" mode

 ALTER DATABASE DBNAME SET MULTI_USER
原文地址：

http://sunali.com/2009/10/08/microsoft-sql-server-error-5030/

转载于:https://www.cnblogs.com/defoliation-love/archive/2011/04/13/2014854.html