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