Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  What collation is this?

Author  Topic  fnirp Starting Member 2 Posts Posted - 2011-03-08 : 09:44:12 Hello! Have a problem, master database is running correct collation (Finnish_Swedish_CI_AI), but one of the user databases is not (Compatibility_185_40b_30003). I want to convert it to the correct one, but before that, I really would like to know more about what this last collation is. Can't find any description on the net :-/ Could it be collation 185, SQL_SwedishStd_Pref_Cp1_CI_AS? (http://msdn.microsoft.com/en-us/library/ms180175%28v=sql.90%29.aspx) Thanks! //Micke