This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › Microsoft SQL Server › The SQL Server server modifies the database collation rules
View: 763|Reply: 1

[Tips] The SQL Server server modifies the database collation rules

[Copy link]
Posted on 2025-9-19 09:44:53 | | |
Requirement: Modify the existing A database collation from SQL_Latin1_General_CP1_CI_AS to Chinese_PRC_CI_AS.

Collation and Unicode support:The hyperlink login is visible.

In SQL Server, if you want to set a database to single-user mode for maintenance operations, such as backup or repair, you can use the ALTER DATABASE statement with the SET SINGLE_USER WITH ROLLBACK IMMEDIATE option. This action puts the database in single-user mode, which means that only the current user can access the database and other users will be denied connection. This is useful for performing actions such as database maintenance tasks or emergency repairs.

The SQL command is as follows:

To quickly gain exclusive access, code samples are usedTermination option WITH ROLLBACK IMMEDIATE. This will cause all outstanding transactions to be rolled back and will immediately disconnect all other connections to the MyTestDatabase database。

Reference:The hyperlink login is visible.




Previous:Nginx reverse proxy ASP.NET Core use UDS communication
Next:ISO 3166 Names of countries and their administrative divisions are representation codes

Related Posts
 Landlord| Posted on 2025-9-19 09:49:56 |
Linux Sql server modifies the default collation (Not tested）


Reference:The hyperlink login is visible.
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com