Recently I wrote article about SQL SERVER – 2008 – Install SQL Server 2008 – How to Upgrade to SQL Server 2008 – Installation Tutorial, I received couple of comment suggesting that I did not talk about SQL Server default collation setting or how to change default collation when installing SQL Server 2008.
While installing SQL Server 2008 on Server Configuration setting select “Collation” tab. It will bring up setting displayed in following image.
You can check the default collation of SQL Server as well can change it from the same. SQL Server offers the SQL_Latin1_General_CP1_CI_AS collation as the default collation for server installations.
Reference : Pinal Dave (http://blog.SQLAuthority.com)