SSMS Database Diagram – backend version is not supported

‘…backend version is not supported…’ was a new one for me. But when you think about it, you can’t use an ‘older’ version of SSMS to create a database diagram of a database on an SQL Server Instance that is a newer version. One option would be to download the latest stand-alone version of SSMS (which will also automatically update itself btw!).

Download SQL Server Management Studio (SSMS)
https://msdn.microsoft.com/en-us/library/mt238290.aspx

SSMS Database Diagram - backend version is not supported








Advertisements

How To: Display unicode characters in Grid Results (SQL Server Management Studio – SSMS)

Is SSMS not displaying unicode characters?
You might want to change the default font to: ‘Arial Unicode MS

In SSMS, go to:
Tools‘ -> ‘Options‘ -> ‘Environment‘ -> ‘Fonts and Colors‘ -> Select ‘Grid Results’

Here you’re able to change fonts for many windows (including ‘Grid Results’).
Also, you can click ‘Use Defaults‘ to (re-)set all settings to default values.

SQL-Server-Management-Studio-SSMS-Unicode-Grid-Results-Settings

Before:
SQL-Server-Management-Studio-SSMS-Unicode-Grid-Results-Before

After:
SQL-Server-Management-Studio-SSMS-Unicode-Grid-Results-After


SSMS 2012 – Log File Viewer enhancements

Today is another SQL adventure 🙂
Just found out that they added a few functionalities/enhancements to SQL Server Management Studio 2012’s ‘Log File Viewer‘.

In 2008 R2, you were not able to directly open the ‘Job Properties‘ or even dive directly into the ‘Job Step Properties‘ of a SQL Job. Guess what…in 2012 this is indeed possible!

SSMS-2012-Log-File-Viewer-Enhancements