SQL SERVER – 2005 Collation Explanation and Translation | Journey to SQL Authority with Pinal Dave

Just a day before one of our SQL SERVER 2005 needed Case-Sensitive Binary Collation. When we install SQL SERVER 2005 it gives options to select one of the many collation. I says in words like 'Dictionary order, case-insensitive, uppercase preference'. I was confused for little while as I am used to read collation like 'SQL_Latin1_General_Pref_Cp1_CI_AS_KI_WI'.… Continue Reading...

Source: SQL SERVER – 2005 Collation Explanation and Translation | Journey to SQL Authority with Pinal Dave