Previous Topic: Database Backup Image for New InstallationsNext Topic: Oracle Database Only: PRJ_BLB_SLICES Table


MS SQL Server Database Compatibility Level

Release 14.1 supports database compatibility levels for SQL Server 2008 (100) and SQL Server 2012 (110). A new installation of Release 14.1 on SQL Server 2008 has the correct compatibility level of 100. If you are using SQL Server 2012 for Release 14.1, set the compatibility level to 110 from SQL Server Management Studio or use the following command:

EXEC SP_DBCMPTLEVEL <database>, 110

Note: SQL Server 2005 compatibility level (90) has been removed and is no longer supported.

To identify the compatibility level, use the following query:

SELECT NAME DATABASENAME ,COMPATIBILITY_LEVEL COMPATIBILITYLEVEL FROM SYS.DATABASES

Upgrade Action: None