We have an SQL Server 2014 (recently upgraded from 2008 R2) instance where one of the databases has some strange settings for collation:
In the Properties window for the database we have the following:
- Under the "General"-tab and Maintenance it says: Collation: Compatibility_60_406_30001
- Under the "Options"-tab the Collation is blank in the drop Down (all though many collations are available for choosing in the list)
I tried googling the collation Compatibility_60_406_30001, but the search came up empty. Anyone have any suggestions on what to do here? So far I have not seen any errors becaus of this, but I would like to choose a valid collation for this database also.