Problem when i try to change collation DB to Arabic

[WaleedE]

Dear support,

When i try to change the collation of the database by using this article.

http://kb.parallels.com/en/871

It's not updated !!

The used query :

alter database 'MYdb_name' collace Arabic_CI_AS

But no effect as below :

SELECT collation_name FROM sys.databases WHERE name = 'MYdb_name'

result :

collation_nameSQL_Latin1_General_CP1_CI_AS


Please advice ..

 

[IgorG]

What is version of your MSSQL server? Have you tried this method - http://msdn.microsoft.com/en-IN/library/ms179254(v=sql.90).aspx ?

 

[WaleedE]

I've changed it by MSSQL Management Studio, but still found error when i try to change it by WebAdmin from Plesk