SqlServerDQECompatibilityLevel SQL Server 2012

Posts   
 
    
MattE avatar
MattE
User
Posts: 77
Joined: 11-Sep-2007
# Posted on: 12-Sep-2013 10:01:43   

http://www.llblgen.com/documentation/2.6/using%20the%20generated%20code/gencode_applicationconfiguration.htm

From the documentation: 2 for SqlServerCompatibilityLevel.SqlServer2005 (also for 2008, which doesn't require a separate compatibility level)

Should this stay as 2 for SQL Server 2012 (this is not documented)

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 12-Sep-2013 10:12:10   

yes, as v2.6 doesn't have sqlserver 2012 compatible code. The queries run fine with setting 1 as well, but using setting 2 you can use features which are introduced in sqlserver 2005, and these are still supported in sql server 2012 simple_smile

In v4 we have a specific setting for sqlserver 2012 to utilize specific features introduced in 2012, namely better paging code.

so for you simply use setting 2, it'll work fine on 2012.

Frans Bouma | Lead developer LLBLGen Pro