I am working on the database side of an upgrade for our Sharepoint site to MOSS 2007. The current environment is SQL Server 2005 (SP2) clustered (8 dual core CPUs, 32GB RAM) with about 0.75 TB of data (about 10 different dbs). I noticed that the collation on the sharepoint databases are not the same as the system databases and other user databases.
The collation setting for our current Sharepoint is:
The collation setting for MOSS is:
The collation setting for our system databases is:
The collation setting for the server is:
Currently nothing is broken, everything is working fine; So my question is:
What does best practices suggest I do in this situation?
Do I leave everything as is? Do I change the server collation and system databases?
Any suggestions and feedback will help.
We have left everything as it is, and we have had no problems. In SQL 2005, the collation in temp tables is governed by the default collation of the user database context the query is run from, so those errors now go away in SQL 2005.