Switching Compatibility Levels on Multiple Databases
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 could certainly do this by clicking through the configuration dialogs for each database as shown here, but for a server with many databases that could take some time. Here are some of the compatibility levels …
Switching Compatibility Levels on Multiple Databases Read more »