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…

Read More

Memory leak in mdsonar.cpp?

One can only guess, but it seems as if there was a memory leak in some method in the mdsonar.cpp file used by Analysis Services. As I was trying to create a cache for a cube, to speed up querying, I ran into the error message listed below: When I binged the filename mdsonar.cpp, I…

Read More