I have been installed the SQL Server 2005 x64 on Windows 2003 R2 EE x64
with default collation settings. It is already in production,recently I
ran the SQLBPASetup.msi to know the server health. In the report I found
the issue about Collation settings that are different for System and User
databases. The recommandation, I read is to rebuild system databases.
System databases: collation: SQL_Latin1_General_CP1_CI_AS
share point databases:collation: Latin1_General_CI_AS_KS_WS
alter db collation
As it is already in Production I do not want to do this. Could you plz
suggest me the method that we can change the user databases collation
settings to match as the system databases.
and is this a serious issue to consider?
set the collation of usre-defined databases to match the of Master
and model databae Database ***** on the server ****** has collation
setting different form master or model databae.We recommend the user defined database to have collation matching .
what is the best way.