To set or change the database collation

1. In Object Explorer, connect to an instance of the SQL Server Database Engine, expand that instance, and then expand Databases.
2. 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.
3. After you are finished, click OK.