Erwin Bierens

Sharing Knowledge

How to change compatibility level of a SQL Database

Get Compatibility level of databases First start checking your version of SQL, start a new query. SELECT SERVERPROPERTY('ProductVersion'); Run Query Now start a new query to check the compatibility level of the databases. SELECT name, compatibility_level FROM sys.databases; Run Query Set Compatibility level Create a new query. ALTER DATABASE databasename SET COMPATIBILITY_LEVEL = 120 Run Query Compatibility Levels Product Database Engine Version Default Compatibility Level Designation Supported Compatibility Level Values SQL Server 2019 (15.

How to obtain your SQL Reporting license key

During the installation of SQL Reporting Services 2019 you will be asked to insert a license key. You don’t need to buy a separate key to make use of full features. Start SQL Server setup Run your SQL Server setup and copy the pre-populated key: Download Reporting Services 2019, run setup, and paste the key: Continue your setup.