SQL Server字符集修改步骤

首先记录好已经安装好的SQLServer数据的相关信息：

--1：记录服务器的所有配置

select *from sys.configurations

--2:记录collation等属性信息

select SERVERPROPERTY('ProductVersion')as ProductVersion,

SERVERPROPERTY('ProductLevel')as ProductLevel,

SERVERPROPERTY('ResourceVersion')as ResourceVersion,

SERVERPROPERTY('ResourceLastUpdateDateTime')as ResourceLastUpdateDateTime,

SERVERPROPERTY('Collation')as Collation

--3：记录data file location信息

select name,physical_nameas current_file_location

from sys.master_files

where database_idin(DB_ID('master'),DB_ID('model'),DB_ID('msdb'),DB_ID('tempdb'))

--4:重新生成数据库

E:\Data\MSSQL10_50.MSSQLSERVER\MSSQL>d:/setup/quiet /ACTION=REBUILDDATABASE /IN

STANCENAME=MSSQLSERVER/SQLSYSADMINACCOUNTS=Administrator /SAPWD=Sap!123456 /SQL

COLLATION=SQL_Latin1_General_CP850_BIN2

其中 d:/setup  d盘是你sql server安装程序所在的目录