I got this error when creating tables from one datase to another SQL Server database today.
- 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
This step is necessary the table level is still sticking to the previous collation