Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sqlanswer
Starting Member
1 Post |
 Posted - 2007-09-07 : 08:13:10
|
Hello. I would like to ask you, if there is any king of tool, which can change the collation of sql server 2000. I want to execute an application, which creates dataset and when I tried to created, it informed me, that it can not happen because the codepage 1253 does not support. I spoke to the technical department, which sells the specific program and they tell me that I must change the collation. I searched to the internet for any king of tool but I can not find something useful. The collation is "Latin1_General_CI_AS". Thanks. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-07 : 10:04:33
|
| change the collation where?on the server, database, column???_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-07 : 23:46:07
|
| If you want to change server collation, you have to rebuild master db. Use 'alter database' or 'alter table' to change collation for db, table or column. |
|
|
|
|
|
|
About the change of Sql Server 2000 collation