SQL SERVER COLLATION
Collation determines how the data should be stored. This stored data can be retrieved in the same format for any execution or compare operation.
Collation can determine options like Case sensitive, Accent Sensitive etc. We can find the collation which the database is assigned by using the following query.
select name,collation_name from sys.databases