SQL Server 2005

How to Change a Database from One Collation to Other

Know the current SQL Database Collation

SELECT DATABASEPROPERTYEX('cBizOne', 'Collation') as SQLCollation

Note: cBizOne Collation: SQL_Latin1_General_CP1_CI_AS

Collation and there meaning:
Link: http://msdn.microsoft.com/en-us/library/ms144250.aspx 

How to change server collation:
The most clear and easy way is to completely reinstall the sql server instance.

How to change database collation:
Step1: Create a new database with collation “SQL_Latin1_General_CP1_CI_AS”
Step2: Import all the tables from current database to new database
Step3: Execute the hosting script
Step4: Create the database user, Catalog and maintenance plan.