‘…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)
That’s a new one…PREEMPTIVE_OS_WAITFORSINGLEOBJECT…causes SSMS being unable to return the list of stored procedures.
Used the ‘sp_who3‘ for the resultset from http://sqlserverplanet.com/dba/a-better-sp_who2-using-dmvs-sp_who3
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.
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!