How to change Database Collation in MsSQL Server?

Collation is a configuration level setting in the MSSQL. It directs how the character data will be handled by the MsSQL Database within the server, database, or column level.

You can change the Database Collation using the SQL Commands as well as from GUI. Following are the steps to change the Collation for a Database on MsSQL.

Note: Consult your Database/Web Developer before making these changes.

  1. Login to the SQL Server using the SQL Management Studio.

  2. Right-Click on the Database name and select the Properties. It will open the Database Properties Dialogue Box.



  3. Click on the Options. You will see the Collation field with the drop-down.



  4. Select your required Collation and click to the OK Button.

You have changed the Database Collation successfully.

Related Articles

Microsoft SQL Server 2012 Recommendation

Microsoft SQL Server 2012 Express is a feature-rich yet FREE data management system. It is far...

How to configure MSSQL server default language configuration option?

Recently, we faced strange issue wherein one of our customers was capturing error messages coming...

How to fix “Reporting Services Catalog Database File Existence” error while installing SQL Server?

You may receive the below error while installing the SQL server on your windows system. This...

How to Restore SQL Server 2012 Database Backup to SQL Server 2008?

Ideally, there is no way you can restore MS SQL Server 2012 database to SQL Server 2008 even if...

Comparison of MS SQL Server 2008 V/s. MS SQL Server 2012

Following is a feature comparison between MS SQL Server 2008 and MS SQL Server 2012. We don't...

  • 0 Users Found This Useful

Was this answer helpful?