How To Change Database Collation

Change Database Collation

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 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 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.

 

Was this answer helpful? 0 Users Found This Useful (0 Votes)