Alter database compatibility on all databases in a SQL Server Instance

(Jack Vamvas) Question: I have a SQL Server Instance with 102 databases at a database compatibility level of SQL Server 2012 (110). I’ve recently migrated all the databases onto a SQL Server 2016 instance – and the database compatibility level is still at 110.

Register to Read