SQL Server modifies collation of data instances

How SQL Server server modifies collations

Operation and verification steps:
1 after you log on to the database, look at the two ways that the default collation of the currently installed database is
After you log in to the database using SQL Server Management Studio, right-click on the linked database server, click Properties, Server Collation, general

Figure 1

Figure 2 Database Properties
Mode two in Query Analyzer, enter select SERVERPROPERTY (' Collation ') to get the server collation

Figure 3
2 View current Server database installation version: Query Analyzer input SELECT @ @VERSION

Figure 4 Viewing the database server version

3 Confirm the default installation version of the current database and the default installation file directory, and log the database default installation directory according to your own version.
Serial number
No database version
(Windows Service) default installation directory

1 SQL Server C:\Program Files\Microsoft SQL Server\100\setup Bootstrap\release
2 SQL Server C:\Program Files\Microsoft SQL Server\110\setup bootstrap\sqlserver2012
3 SQL Server C:\Program Files\Microsoft SQL Server\120\setup bootstrap\sqlserver2014
4 SQL Server C:\Program Files\Microsoft SQL Server\140\setup bootstrap\sqlserver2016

4 Open the DOS command line with Administrator privileges:

Figure 5 Entering the DOS command line

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

Figure 6 Entering the SQL Server installation directory

6 using the Net stop MSSQLSERVER statement to turn off SQL Server Background services

Figure 7 Closing the SQL Server service

8 running the statement setup/quiet/action=rebuilddatabase/instancename=mssqlserver/sqlsysadminaccounts=administrator/[email Protected]/sqlcollation=chinese_prc_cs_as
Format Description:
Setup/quiet/action=rebuilddatabase/instancename=instancename
/sqlsysadminaccounts=accounts/[sapwd= StrongPassword]
/sqlcollation=collationname)
Note: Accounts users use the computer administrator user, CollationName is the sort format that needs to be changed

Figure 8 Modifying the language format

9 Input Statement net start MSSQLSERVER start SQL Server Service

Figure 9 Starting the SQL Server service

10 Verify that the collation is in effect, repeat step 1 for review.

SQL Server modifies collation of data instances