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;