Changing Server Default Collation
来源:互联网 发布:测速传感器接单片机 编辑:程序博客网 时间:2024/04/29 19:57
From:
http://sqlblog.com/blogs/allen_white/archive/2009/05/29/changing-server-default-collation.aspx?CommentPosted=true#commentmessage
An interesting problem develops when the standard default collation for SQL Server isn't appropriate. Working with clients here in the Czech Republic, I have to reset our lab systems server default collation to Czech_CI_AS, and I found it difficult to find out how to do this via Books Online. Since we have systems running SQL 2000, SQL 2005 and SQL 2008, I have to be able to make these changes in each version, and each version has a different method for accomplishing this.
In SQL 2000, you must run rebuildm.exe in the SQL Server binaries directory, and set the collation in the setup dialog.
In SQL 2005, the following command will reset it:
setup.exe /qb INSTANCENAME=[instance] REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[password] SQLCOLLATION=[new collation]
In SQL 2008, the command is slightly different:
setup.exe /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=[instance] /SQLSYSADMINACCOUNTS=[admin account] /SAPWD=[password] /SQLCOLLATION=[new collation]
Note that you should do this before loading ANY databases or logins. If you've already done so, detach the databases and script the logins using something like sp_help_revlogin (search the Microsoft KB articles for your version). Then, after rebuilding the master database, you can reattach the databases and reload the login accounts.
Collations can be very tricky, and when you're testing application compatibility it's important that issues like this are correctly handled so your testing is valid.
- Changing Server Default Collation
- 更改SQL Server服务器默认collation设置(Changing Server Default Collation )
- Changing the default port in WebSphere Application Server
- Changing Flex default workspace
- mysql中utf-default collation
- SQL Server Collation介绍
- SQL SERVER 2005 COLLATION 详解
- Sql server 日记 (Collation)
- sql server 2005 Collation 冲突
- Sql server中Collation …
- Sql server中Collation conflict问题
- SQL Server Collation引发的惨案
- Sql server中Collation conflict问题
- Sql server中Collation conflict问题
- SQL Server 更改DB的Collation
- SQL Server 学习笔记之Collation(校对)
- Changing the default skins on a Button control in Flex
- Changing the name of your SQL Server
- 动态创建二维数组
- 李开复给中国学生的七封信
- 关于 发布网站时候的 单页程序集的解释
- 关于GJB438A-97软件设计文档的疑问
- 解决Linux中文乱码
- Changing Server Default Collation
- 在ASP.NET中使用Treeview控件和XML
- 开发符合Web网站结构与表格分离的页面
- 为自己的RCP产品的视图和编辑器添加圆角标题栏属性
- Stupid Keyboard
- 专题 - 项目经理应该小心的游戏
- rsync简介
- css图片滤镜大全
- 专题 - 作团队感悟