Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS”Usman
I got this error when creating tables from one datase to another SQL Server database today.
How to solve it:
- Change to single-user mode in your database
Command to change Single-User mode or Mutilple-User mode in sql server
databaseALTER DATABASE [Works] SET MULTI_USER WITH
NO_WAITALTER DATABASE [Works] SET SINGLE_USER WITH
2. Change the collation of from Latin1_General_CI_AS to SQL_Latin1_General_CP1_CI_AS
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.