Steps to change Database Collation in MSSQL Server


Staff member
Collation indicates that how character data will be handled. Collation is a configuration level setting.

You can follow below steps to change database Collation:
  • Login to RDP server and open SQL Management Studio.
  • Now right click on particular Database name and then click on “Properties”.
  • A new dialoge box will open where you have to click on “Options” and then click drop-down of “collation” field.
  • Now select the required Collation and click on OK button.