How to Change Database Collation to SQL Server
In that Example We will change the Database Collation from Case Insensitive to Case Sensitive. The collation Name in the picture is Finish_Swedish_CS_AS where CS stand for Case Sensitive and we will change it to Finish_Swedish_CI_AS where CI Stands for Case Insensitive.
Change Collation Using T-SQL:
USE [master] GOALTER DATABASE [Sales] COLLATE Swedish_Finish_CI_AS GO