To set or change the database collation
- In Object Explorer, connect to an instance of the SQL Server Database Engine, expand that instance, and then expand Databases.
- If you are creating a new database, right-click Databases and then click New Database. If you do not want the default collation, click the Options page, and select a collation from the Collation drop-down list.Alternatively, 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.
- After you are finished, click OK.