How to set column collation in SQL server

Developers set column collation when the users of their instance of SQL server speak multiple languages. In this keys developers should pick a collation that best supports the requirements of the various languages.When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to set column collation, they should follow the next steps:

1. In Object Explorer, right-click the table to which they want to add columns and choose Design (Modify in SP1 or earlier). The table opens in Table Designer.

2. Select the column for which they want to set the collation.

The properties for that column appear in the Column Properties tab.

3. Click Collation and then click the ellipses (…) to the right of the property.

The Collation dialog box appears.

4. Choose collation settings for the selected column in the Collation dialog box.