This question can be found multiple times on the ms sql server forums, so I've decided to pen down it on the,Simple!! Once can use Alter Database command to change the collation settings for the specific database, below is the command you've to execute:
ALTER DATABASE testDB
COLLATE French_CI_AI ;
GO
