Tag Archives: SSMS

Never loose your server list in SSMS again…

Posted on 30/01/2014 by Jens Vestergaard

Having to install new laptops, re-install old ones, configuring virtual servers or whenever you get the opportunity to install SQL Server from scratch, you always end up with an empty list of servers, when you try to connect through SQL … Continue reading →

Posted in Programming | Tagged , , | 3 Comments

Server and column collation conflicts in properties of a login

Posted on 30/05/2012 by Jens Vestergaard

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

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

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

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