hi We have wrong collation on our database axdb: Polish_CI_AI and we don’t have polish letters. I would like to change the collation. Has anybody tested expression like this: ALTER DATABASE axdb COLLATE Polish_CI_AS or is there another method of changing the collation. Slawek
Hi Slawek AFAIW, there are no other ways to change collation. Also, instead of changing collation just for the database, you might want to change collation for the entire server. The main reason - - Changing collation of a database does not change the collation settings of columns in existing tables. - Also changing collation of server would definitely be helpful in minimizing collation issues between different databases (should you decide to host databases in other collations) In any case, do please refer to this article - http://www.databasejournal.com/features/mssql/article.php/10894_2013741_2 The above article discusses changing collation for database and entire server as well. All the best [:)] Harish Mohanbabu