-- Changing Collation setting at Database Level  

ALTER DATABASE  TEST  COLLATE French_CI_AI ;

-- Script that returns all your databases' collations

 select name, collation_name from sys.databases