Compatibility Level

Switching Compatibility Levels on Multiple Databases

by SteveStedman
June 28, 2020June 29, 2020
2 Comments
SQL 2019

Recently as part of an upgrade to SQL Server 2019, I needed to set the compatibility levels for a database to 150 (for 2019). You… Read More »Switching Compatibility Levels on Multiple Databases

SQL Server 2019 Compatibility Level

by SteveStedman
November 11, 2018November 13, 2018
2 Comments
SQL 2019, TSQL

With SQL Server 2019, there is a new compatibility level introduced, level 150 the new SQL Server 2019 Compatibility Level. SQL Server can run in… Read More »SQL Server 2019 Compatibility Level

SQL Server 2017 Compatibility Levels

by SteveStedman
November 11, 2017November 11, 2018
SQL 2017, TSQL

With SQL Server 2017, there was a new compatibility level introduced, level 140 the new SQL Server 2017 Compatibility Level. SQL Server can run in a… Read More »SQL Server 2017 Compatibility Levels

SQL Server 2016 Compatibility Level

by SteveStedman
November 11, 2016November 11, 2018
TSQL

With SQL Server 2016, there was a new compatibility level introduced, level 130 the new SQL Server 2016 Compatibility Level. SQL Server can run in a… Read More »SQL Server 2016 Compatibility Level

SQL Server 2014 Compatibility Level

by SteveStedman
July 30, 2014July 30, 2015
SQL 2014

With SQL Server 2014, there was a new compatibility level introduced, level 120 the new SQL Server 2014 Compatibility Level. SQL Server can run in a… Read More »SQL Server 2014 Compatibility Level