Change Database Collation

Overview

Databases that have a different collation with the server are placed in the Collation Issue folder. These databases cannot be processed unless that database collation is the same as the server. To fix this, you can use the Change Server Collation option in the Database Management Console.


Steps

To change the database collation,

  1. Select the database (or multiple databases) from the Collation Issue folder.
  2. Click on the Change Server Collation button (1) in the toolbar menu. Alternatively, you can use the right click menu and select Change to Server Collation or use the Change to Server Collation icon (2) in the Database Summary Section.

  3. A message prompt will appear confirming the change of collation. Click Yes to confirm.

  4. You will be prompted once the collation is successful.

 

 

 

  • Monday, 15 October 2012