Set or Change DB Collation

Set or Change DB Collation

How to Set or Change the Database Collation using SQL Server Management studio

Default MS SQL 2008 collations - http://puu.sh/lJvpI.txt
Other collations - http://puu.sh/lJvG0.txt
  1. Before proceeding with any changes, first initiate a full backup of client’s DB. Then, prompt them for a full name of the collation they want to set up.
  2. In Object Explorer, connect to an instance of the SQL Server Database Engine, expand that instance, and then expand Databases.
  3. If the database already exists, right-click the database that you want and click Properties. Click the Options page, and select a collation from the Collation drop-down list.
    Note: do not change the collation until client verifies its full name from the drop down list selected matches exactly or their DB will be lost completely.
  4. After you are finished, click OK.