不用重SQL2005怎其默的字符集改其它的字符集啊?
我的服器是win2003英文版的，安SQL2005默字符集Latin1_General_CI_AI
在怎么其改Chinese_Taiwan_Stroke_CI_AS啊？
不用重新安行？


[解决办法]
关注,学习
[解决办法]
修改注册表：HEKY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer下DefaultCollationName的值,做之前最好做下备份.这个方法本人没有试过!
[解决办法]
不好意思，看错了，上面是2000的处理！
[解决办法]
try to search How to: Install SQL Server 2005 from the Command Prompt

To rebuild system databases and specify a new system collation
Insert the SQL Server 2005 installation media into the disk drive.

Run the following command from the command prompt:

Copy Code
start /wait <DVD Drive> \setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD= <NewStrongPassword> SQLCOLLATION= <NewSystemCollation>


For INSTANCENAME, use MSSQLSERVER for a default instance. For a named instance, specify the instance name.

Important The resource database (mssqlsystemresource) is restored from SQL Server 2005 distribution media. When you rebuild the resource database from distribution media, all Service Packs and QFE updates are lost, and therefore must be reapplied. Before you proceed, see the section below on REBUILDDATABASE for more information.

The /qn switch suppresses all Setup dialog boxes and error messages. If the /qn switch is specified, all Setup messages, including error messages, are written to Setup log files. For more information about log files, see How to: View SQL Server 2005 Setup Log Files.

The /qb switch allows display of basic Setup dialog boxes. Error messages are also displayed.