Note that changing server or database collation does NOT change the collation for pre-existing columns/data. There's only one way to do that:

Create a brand new empty database in the desired collation and migrate the data into that DB.

Simplest thing to do is to use the COLLATE option, though (as mentioned above).

MSSQLTIPS just had an article on that today: slightly different context but same issue