After installing a new SQL Server 2016 or after upgrading your SQL Server to the latest version, you may get a strange issue. Open the SQL Server Management Studio, and you may notice that the compatibility level dropdown for all your databases is blank. What’s wrong here?
Issue
Fix
It will happen when you use lower version SQL Server Management Studio to connect to higher version SQL Server instance. So to solve this issue, simply run SSMS 2014 or SSMS 2016 and the list will be populated!
It works!
Thanks to this blog: blog.sqlauthority.com, I solved my issue.
Thanks for reading! You can follow me on Twitter @PrigentNico