I recently ran into problems with mismatched server & database collation on a project not associated with EPDM whatsoever. After fixing the problem I decided to check my EPDM database server to see what collations have been chosen. I noticed that the SQL Server 2005 default collation is set to "SQL_Latin1_General_CP1_CI_AS" which is a compatible with previous versions of SQL Server (designated by the "SQL_" prefix). I verified all the system databases (master, model, msdb and tempdb) and they were all set to the same collation as the server default.
Then I checked the two EPDM databases and found that the ConisioMasterDb database was the same as the server default as well but our actual vault database was set to "Latin1_General_CI_AS_KS_WS". Our VAR used a pre-loaded database to kickstart our vault setup. Is this the proper collation for the vault databases? If not, does anyone know if this could cause a problem? I only ask because we sometimes experience weird problems and poor database performance.
Thanks in advance to those that can shed some light on this matter.