SQL Server 5030错误解决办法
今天在使用SQL Server时，由于之前创建数据库忘记了设置Collocation，数据库中插入中文字符都是乱码，于是到DataBase的Options中修改 Collocation，出现了The database could not be exclusively locked to perform the operation这个错误，无法修改字符集为Chinese_PRC_90_CI_AS。
解决办法找了很久才找到，如下：
1.执行SQL ALTER DATABASE db_database SET SINGLE_USER WITH ROLLBACK IMMEDIATE
修改为单用户模式
2.然后关闭所有的查询窗口，修改Options的Collocation属性为Chinese_PRC_90_CI_AS
3.执行SQL ALTER DATABASE db_database SET MULTI_USER
再修改为多用户模式
相关推荐
In this scenario, since T1 believes it locks the entire table, it might inadvertently make changes to the same row that T2 thought it has locked exclusively. In a multigranular locking environment, ...
· What is the best way to query information from the database? · How can I get all the developers on my team to handle errors the same way? So many questions, so much burning desire to write code ...
6. The software shall not be used with or in connection with the operation of nuclear power plants, airplanes, communication systems, flight monitoring, as well as life-preserving equipment or other ...
would be a good idea to have a quick look at the demos. The library has been completely rewritten and a lot of new features has been added. ------------------------------------------- 4. Known ...
"SQL injection is probably the number one problem for any server-side application, and this book is unequaled in its coverage." Richard Bejtlich, http://taosecurity.blogspot.com/ SQL injection ...
However, most machine learning courses focus almost exclusively on the algorithms, not the human-computer interaction part of the systems. This can leave a big knowledge gap for data scientists ...
You intend to be legally bound to this EULA to the same extent as if Steema and you physically signed this EULA. By installing, copying, or otherwise using the SOFTWARE, you agree to be bound by ...
This one hundred page book focuses exclusively on how you can best use the ASP.NET MVC 4 Framework to build world-class REST services using the Web API. It sets aside much of what the ASP.NET MVC ...
Until modern times cryptography referred almost exclusively to encryption, which is the process of converting ordinary information (plaintext) into unintelligible gibberish (i.e., ciphertext).[2] ...
Up to a few years ago, the...The results achieved are not limited to Verilog. The approach taken was carefully chosen so as to be applicable to other standard hardware description languages such as VHDL.
You intend to be legally bound to this EULA to the same extent as if Steema and you physically signed this EULA. By installing, copying, or otherwise using the SOFTWARE, you agree to be bound by ...
The Microsoft clients can be configured to use a UB name server by adding the SYSTEM.INI parameter RefreshOpCode under the [NBT] section. Set its value to 9 to interoperate with UB name servers. ...
A successful application may be constructed using the Object Relational Mapper exclusively. In advanced situations, an application constructed with the ORM may make occasional usage of the Expression ...
It is the only book on the market that focuses exclusively on memory forensics and how to deploy such techniques properly. Discover memory forensics techniques: How volatile memory analysis improves ...
The fourth edition covers Hadoop 2 exclusively. The Hadoop 2 release series is the current active release series and contains the most stable versions of Hadoop. There are new chapters covering YARN ...
agreed it might be time to bring in a helping and capable hand to update portions of the text. Apress suggested that I meet with Philip Japikse to see whether he might be a good match. After a series ...
The Delphi 2010 Handbook is expected to have about 300 pages covering exclusively new Delphi 2010 features. There is no introduction material or anything like that. The book is for developers who use...
Do not try to access the drive while update is in process. 3-3. The firmware update may not work properly while certain packet writing software is installed. In this case, you must first ...
The primary goal of the engineer is to ensure proper operation and performance of a product when used within an intended electromagnetic environment. These design requirements are in addition to ...
In any case, the MT Solution entire liability under any provision of this EULA shall be limited EXCLUSIVELY TO PRODUCT REPLACEMENT. The MT Solution reserves all rights not expressly granted here.