SQL Server: contained database collation and collation conflicts
The fixed Latin1_General_100_CI_AS_WS_KS_SC collation of contained databases and how to avoid conflicts.
A contained database uses a fixed catalog collation: Latin1_General_100_CI_AS_WS_KS_SC. If the instance collation differs, collation conflict errors can appear, for example when comparing columns of the contained database with temporary tables (tempdb).
Latin1_General_100_CI_AS_WS_KS_SC
To avoid these errors, use this collation in the affected queries or column definitions (COLLATE clause), or align the objects involved with it.
References: