* An existing SQL-server with a lot of databases
* Server collation order: SQL_Latin1...
I need to install a new databas that must use Finnish_Swedish collation. I also need the server collation to be the same since it uses a lot of temporary tables (that will use server default as collation). Due to the size and complexity of the databas it's not an option to rewrite all SP and SQL-code so that the collation problem is taken care of in every sql-statement involving temporary tables.
Is it possible to change the server collation and preserving the installed databases?
If so, how?