What will happen with CATALOG_COLLATION and Case Sensitive vs Case Insensitive

One of the options available when creating a database is the CATALOG_COLLATION, by default this is going to be SQL_Latin1_General_CP1_CI_AS , even if you take the trouble of specifying a database collation , the catalog collation will be SQL_Latin1_General_CP1_CI_AS unless you say otherwise. If you do not set this parameter it will not use the…