The procedure is as follows:
1. Find the installation package of sql2005
2. Execute the following batch processing
The content is as follows:
Cd d: \ SQL Server 2005 \ SQL Server x86 \ servers
Start/Wait setup.exe/QB InstanceName = MSSQLServer reinstall = SQL _engine rebuilddatabase = 1 sapwd = sa sqlcollation = chinese_prc_ci_as
3. If the database cannot be found after the modification, append the database.
_ Bin
binary sorting
_ ci_ai
case-insensitive, stress-insensitive, Kana-insensitive, and half-width-insensitive
_ ci_ai_ws
case-insensitive, and Kana-insensitive
_ ci_ai_ks
case-insensitive, stress-insensitive, and case-insensitive kana type, not all halfwidth
_ ci_ai_ks_ws
case-insensitive, case-insensitive, accent-insensitive, ks_ws-differentiated, and full halfwidth
_ ci_as
case-insensitive, stress-sensitive, and Kana-insensitive
_ ci_as_ws
case-insensitive, case-insensitive, and stress-insensitive kana type, full halfwidth differentiation
_ ci_as_ks
case-insensitive, stress-sensitive, Kana type-insensitive
_ ci_as_ks_ws
case-insensitive, accent-sensitive, and Kana-specific
_ cs_ai
case-sensitive, accent-insensitive, and Kana-type-insensitive, case-insensitive
_ cs_ai_ws
case-sensitive, case-insensitive, Kana-insensitive, and full-halfwidth
_ cs_ai_ks
case-sensitive, accent-insensitive, Kana-specific, and case-insensitive
_ cs_ai_ks_ws
case-sensitive, accent-insensitive, and Kana-specific halfwidth
_ cs_as
case sensitive, stress sensitive, but not Kana type, and case sensitive
_ cs_as_ws
distinguish accent, not Kana type, distinguish full halfwidth
_ cs_as_ks
case sensitive, distinguish accent, distinguish Katana type, do not distinguish full halfwidth
_ cs_as_ks_ws
case sensitive, stress sensitive, Kana type, and halfwidth sensitive