Server and column collation conflicts in properties of a login

Problem: Error: Cannot resolve the collation conflict between “Danish_Norwegian_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the UNION operation. (Microsoft SQL Server, Error: 468) when clicking “Securables” in properties of a server login. Setup: Server is set up with collation: SQL_Latin1_General_CP1_CI_AS The database, or more precisely, the columns are created with collation: Danish_Norwegian_CI_AS Login is set up with default […]