SCCM SQL Collation Modification method

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

650) this.width=650; "alt=" View SQL Server server Collation "height=" 563 "src=" http://www.2cto.com/uploadfile/Collfiles/20170405 /20170405092357240.png "width=" "style=" border-width:0px;padding:0px;margin:0px;list-style:none;height:560px; width:437.655px; "/>

Figure 1

650) this.width=650; "alt=" View SQL Server server Collation "height=" 631 "src=" http://www.2cto.com/uploadfile/Collfiles/20170405 /20170405092357241.png "width=" 693 "style=" border-width:0px;padding:0px;margin:0px;list-style:none;height:560px; width:615.024px; "/>

Figure 2 Database Properties

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

650) this.width=650; "alt=" View SQL Server server Collation "height=" 215 "src=" http://www.2cto.com/uploadfile/Collfiles/20170405 /20170405092357242.png "width=" 449 "style=" BORDER-WIDTH:0PX;PADDING:0PX;MARGIN:0PX;LIST-STYLE:NONE;WIDTH:449PX; height:215px; "/>

Figure 3

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

650) this.width=650; "alt=" here write a picture describing "height=" 186 "src=" http://www.2cto.com/uploadfile/Collfiles/20170405/ 20170405092357243.png "width=" 712 "style=" border-width:0px;padding:0px;margin:0px;list-style:none;width:630px; height:164.579px; "/>

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:

650) this.width=650; "alt=" Open the DOS directory "height=" 254 "src=" http://www.2cto.com/uploadfile/Collfiles/20170405/ 20170405092357244.png "width=" 786 "style=" border-width:0px;padding:0px;margin:0px;list-style:none;width:630px; height:203.588px; "/>

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

650) this.width=650; "alt=" here write a picture describing "height=" 281 "src=" http://www.2cto.com/uploadfile/Collfiles/20170405/ 20170405092357245.png "width=" "style=" border-width:0px;padding:0px;margin:0px;list-style:none;width:630px; height:146.669px; "/>

Figure 6 Entering the SQL Server installation directory

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

650) this.width=650; "alt=" closes the SQL Service "height=" 325 "src=" http://www.2cto.com/uploadfile/Collfiles/20170405/ 20170405092357246.png "width=" "style=" border-width:0px;padding:0px;margin:0px;list-style:none;width:630px; height:166.735px; "/>

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

650) this.width=650; "alt=" Modify the Database Sort "height=" 229 "src=" http://www.2cto.com/uploadfile/Collfiles/20170405/ 20170405092357247.png "width=" "style=" border-width:0px;padding:0px;margin:0px;list-style:none;width:630px; height:119.726px; "/>

Figure 8 Modifying the language format

9 Input Statement net start MSSQLSERVER start SQL Server Service

650) this.width=650; "alt=" Start SQL Service "height=" src= "http://www.2cto.com/uploadfile/Collfiles/20170405/" 20170405092357248.png "width=" 1138 "style=" border-width:0px;padding:0px;margin:0px;list-style:none;width:630px; height:149.473px; "/>

Figure 9 Starting the SQL Server service

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

This article is from the "Lao Mo" blog, please be sure to keep this source http://2717799802.blog.51cto.com/9071389/1923908

SCCM SQL Collation Modification method