Skip to main content
Planview Customer Success Center

SQL Server 2014 compatibility level

On installing Changepoint on SQL server v2014 SP2 (version 12.0.5000.0) the compatibility setting is changed to 110.  On changing this value to 120 as recommended for v2014,  Changepoint does not work.  How to use of the recommended settings for SQL Server 2014 SP2?


For both  SQL Server 2014 and SQL Server 2012 the compatibility level is 110 on Changepoint 2014 SP2, changing it would result in unexpected errors.

To view or change the compatibility level of a database using SQL Management Studio, use the following steps:

  1. After connecting to the appropriate instance of the SQL Server Database Engine, in Object Explorer, click the server name.
  2. Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.
  3. Right-click the database, and then click Properties.The Database Properties dialog box opens.
  4. In the Select a page pane, click Options.The current compatibility level is displayed in the Compatibility level list box.
  5. To change the compatibility level, select a different option from the list. The choices are SQL Server 2012 (110), or SQL Server 2014 (110)