Query: How to change a Sql Server database collation

To change a Sql Server database collation, do the following:

• Connect to the Database Engine
• From the Standard bar, click New Query
• Copy and paste the following into the Query window and click Execute:
  ALTER DATABASE Licence SET RESTRICTED_USER;
ALTER DATABASE Licence COLLATE SQL_Latin1_General_CP1_CI_AS;
ALTER DATABASE Licence SET MULTI_USER;
ALTER DATABASE DeMaSy SET RESTRICTED_USER;
ALTER DATABASE DeMaSy COLLATE SQL_Latin1_General_CP1_CI_AS;
ALTER DATABASE DeMaSy SET MULTI_USER;