不用重裝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.