The blog about Microsoft products by Matthias Schlomann
 Matthias Schlomann
 18  3639  12/9/2015

Query and modify the database compatibility level to SQL DNN

By Matthias Schlomann on 11/6/2013

Since DNN Platform / evoq 7.0 of the SQL Server 2008 is a minimum requirement for DNN Platform and evoq editions. When upgrading the database or changing to another MS SQL Server compatibility level is not changed automatically , and has to be done manually. For this one can on the Execute SQL feature in DNN create a query in query system to obtain the compatibility level .


For this purpose, the following command can be executed ( <databasename> be replaced by the database name ! ):


Select compatibility_level
From sys.databases WHERE name = ' <databasename> ';


As output we get the following values ​​:


110 = MS SQL Server 2012/2012 R2
100 = MS SQL Server 2008/ 2008 R2
90 = MS SQL Server 2005

80 = MS SQL Server 2000

and is approximately as shown :



In this case, the compatibility level on MS SQL Server 2005 is set and should be set to at least 100, so that the minimum requirements for DNN 7.0 are met.

However, that we can change this with safety , we need a MS SQL Server 2008 or later . We should then opt for the highest degree of compatibility . The SQL Server version we can check the 'System Info ' function without prompting with the system.

If we assume that a MS SQL Server 2012 is used , we should now set the compatibility level to 110. This can also be performed using the Execute SQL function under System as a script query.


The query should look like this ( <databasename> must be replaced by the database name! ) and 'Run as script' have to be enabled:


ALTER DATABASE <databasename>

We can now perform the previous code again to check whether the change was made.
Now upgrading to DNN 7.x can be start .


Privacy Statement | Terms Of Use | © 1994-2023 by AARSYS - Matthias Schlomann