Shulou(Shulou.com)06/03 Report--

The method of modifying collation by SQL Server Server

Operation and verification steps:

1 after logging in to the database, there are two ways to view the default collation of the currently installed database

Method 1. After logging in to the database using SQL Server 2014 Management Studio, right-click on the linked database server, click Properties, and click Server Properties-> General-> Server collation.

Figure 1

Figure 2 Database properties

Method 2: in the query analyzer, enter SELECT SERVERPROPERTY ('Collation') to get the server collation

Figure 3

2 View the current installation version of the server database: query Analyzer enter SELECT @ @ VERSION

Figure 4 View the database server version

3 Please confirm the current default installation version of the database and the default installation file directory, and record the default installation directory of the database according to your own version.

Serial number

No database version

(Windows Service) default installation directory

1 SQL Server 2008 C:\ Program Files\ Microsoft SQL Server\ 100\ Setup Bootstrap\ Release

2 SQLServer2012 C:\ Program Files\ Microsoft SQLServer\ 110\ Setup Bootstrap\ SQLServer2012

3 SQLServer2014 C:\ Program Files\ Microsoft SQLServer\ 120\ Setup Bootstrap\ SQLServer2014

4 SQLServer2016 C:\ Program Files\ Microsoft SQLServer\ 140\ Setup Bootstrap\ SQLServer2016

4 Open the DOS command line with administrator privileges:

Figure 5 enter the DOS command line

5 use CD + default installation directory path to enter the corresponding version database installation file directory

Figure 6 enter the SQL Server installation directory

6. Use Net stop mssqlserver statement to shut down the SQL Server background service

Figure 7 shutting down the SQL Server service

8 run the statement Setup / QUIET / ACTION=REBUILDDATABASE / instancename=MSSQLSERVER / SQLSYSADMINACCOUNTS=administrator / sapwd=bwi@1234 / sqlcollation=Chinese_PRC_CS_AS

Format description:

Setup / QUIET / ACTION=REBUILDDATABASE / INSTANCENAME=InstanceName

/ SQLSYSADMINACCOUNTS=accounts / [SAPWD= StrongPassword]

/ SQLCOLLATION=CollationName)

Note: accounts users use computer administrator users. CollationName is the sort format that needs to be changed.

Figure 8 modify the language format

9 enter the statement Net start mssqlserver to start the SQL Server service

Figure 9 start the SQL Server service

10 to verify that the collation is in effect, please repeat step 1 to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.