Set Compatibility Level on All DBs

Subject: Set Compatibility Level on All DBs

/* Update All DBs Compatibility Level */

/* Reference

2017 = 140

Azure SQL Database = 130

2016 = 130

2014 = 120

2012 = 110

2008R2 = 100

2008 = 100

2005 = 90

2000 = 80

*/

DECLARE @SQL VARCHAR(max) = ”, @CL int =

Leave a Reply

Your email address will not be published. Required fields are marked *