Collation conflict in MS SQL Server 2005 / 2008

Issues of SQL Server Collation and Solution

“SQL_Latin1_General_CP1_CI_AS” in the UNION operation. (Microsoft SQL Server, Collation conflict in MS SQL Server, collation error, Error:468), Latin1_General_CI_AS, SQL server collation, SQL_Latin1_General_CP1_CI_AS.

Solution

To Resolve by changing server collation:

1. Backup all user DB.

2. Drop all user DB.

3. Open Command Prompt on elevate mode.

4. Run the following at the SQL server setup.exe directory

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=InstanceName

/SQLSYSADMINACCOUNTS=accounts /[ SAPWD= StrongPassword ]

/SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

5.Restore all User DB