Mini Post: Change Database Collation

So just to get this one out of the way (was bugging me that I didn't write it as yet), here's how to change the collation of a database. (See bottom of post for links to other related collation posts)

Use only one of the following solutions: EITHER Management Studio OR TSQL.

Management Studio

• Right click the DB in question.
• Select Properties.
• Select 'Options' on the left in the Properties window.
• Select the collation of your choice from the dropdown, click Ok.

Fig. 1: Database collation settings.

TSQL

Run the following in a new query window:

USE master;
GO
ALTER DATABASE MyOptionsTest
COLLATE French_CI_AS ;
GO

And that's all there is to it. 

Related Posts:

Change SQL Instance Collation

Change Database Collation

Change Column Collation

Adjust Queries to ignore Collation 

DISCLAIMER: As stated, I’m not an expert so please, PLEASE feel free to 
politely correct or comment as you see fit. Your feedback is always 
welcomed. :-)