Nov
1

Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS”

I got this error when creating tables from one datase to another SQL Server database today.

How to solve it:
  1. Change to single-user mode in your database
Command to change  Single-User mode or Mutilple-User mode in sql server
database
ALTER DATABASE [Works] SET MULTI_USER WITH
NO_WAIT
ALTER DATABASE [Works] SET SINGLE_USER WITH
NO_WAIT
     2.  Change the collation of from Latin1_General_CI_AS to SQL_Latin1_General_CP1_CI_AS
SQL Server Database Properties

SQL Server Database Properties

   3.  Drop and re-create those tables which are still using collation Latin1_General_CI_AS in their columns.
This step is necessary the table level is still sticking to the previous collation
     4.  Restore the data of those tables.
Be Sociable, Share!

Tags: ,

Posted by admin SQL Server Subscribe to RSS feed

Leave a Reply

CAPTCHA Image

*