Tag Archives: SQL2008

Server and column collation conflicts in properties of a login

Posted on 30/05/2012 by Jens Vestergaard
Share

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 … Continue reading →

Posted in Programming | Tagged , , , | 2 Comments

Parameter ordering in SSRS – Gotcha!

Posted on 09/05/2012 by Jens Vestergaard
Share

After banging my head against the screen for about three or four hours, trying to solve what seemed as a Reporting Services mystery, a coworker of mine came up with the solution. I was trying to inject a role into an embedded … Continue reading →

Posted in Programming | Tagged , | Leave a comment

Memory leak in mdsonar.cpp?

Posted on 07/05/2012 by Jens Vestergaard
Share

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, … Continue reading →

Posted in Programming | Tagged , , | Leave a comment