Previous Topic: Upgrade suggestion for Niku 6.x, Clarity 7.x, and CA Clarity 8.xNext Topic: Java 7


MS SQL Server Database Compatibility Level

Release 13.3 supports database compatibility levels for SQL Server 2008 (100) and SQL Server 2012 (110). A new installation of Release 13.3 on SQL Server 2008 has the correct compatibility level of 100. If you are using SQL Server 2012 for Release 13.3, 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