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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Server collation

Author  Topic 

Oliver wang
Yak Posting Veteran

50 Posts

Posted - 2010-11-10 : 01:00:46
Hello everyone,

I got a issue here. Now I have a sql instance whose server collation(not database collotion) is Chinese_PRC_CI_ AS. But actually the collation should be SQL_Latin1_General_CP1_CI_AS. Now i want to change it, is there an easy way to achieve that instead of installing a new instance?

Thanks a lot for your time and effort.

regards,

Oliver

chadmat
The Chadinator

1974 Posts

Posted - 2010-11-11 : 04:13:02
http://msdn.microsoft.com/en-us/library/ms179254.aspx


-Chad
Go to Top of Page

Oliver wang
Yak Posting Veteran

50 Posts

Posted - 2010-11-17 : 02:49:11
Thanks Chad, I have solve this issue using the link you provided.
Go to Top of Page
   

- Advertisement -