Tag Archives: SSMS

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

SSMS Quick Tip

Posted on 23/02/2012 by Jens Vestergaard
Share

If you ever need to test Analysis Services roles, you can easily do so either by browsing the cube or by means of a query. When browsing a cube through SQL Server Management Studio (SSMS) or Bisuness Intelligence Developer Studio (BIDS), you … Continue reading →

Posted in Programming | Tagged , , , , , , , , | Leave a comment

Quick-tip: Default column type in SSMS

Posted on 24/09/2011 by Jens Vestergaard
Share

Looking for some other settings I stumbled upon this very nice, and very hidden, feature in SQL Server Management Studio (SSMS): The ability to set your default column type! That should save me a lot of time, from now on.

Posted in Programming | Tagged , , | Leave a comment

Server og database collation clasher i sikkerhedsindstillingerne for en bruger

Posted on 26/01/2011 by Jens Vestergaard
Share

Tænkte jeg lige ville dokumentere hvilke skridt der skal til, for at reproducere en lidt underlig fejl i SQL Server Management Studio 2008 (SSMS). Setup: Serveren er sat op med collation: SQL_Latin1_General_CP1_CI_AS Databasen er oprettet med collation: Danish_Norwegian_CI_AS Login er oprettet med … Continue reading →

Posted in Programming | Tagged , , , | Leave a comment