SQL Server 2016 (130) compatibility level

We are locally hosted, and running Tess v15.0.5 on SQL Server v16 with no issues. According to support, for v15 "SQL Server 2012, 2014, or 2016 Standard or Enterprise, with current Service Pack will work".

HI Chris - the question wasn't about SQL Server version, but the database compatibility level. For example, you can be running SQL Server 2016, but have a database set to SQL Server 2014 (120) compatibility level (which is what we are currently using). You can find this value in database properties in the Options section labeled, "Compatibility level". You can also find it via this script:

SELECT compatibility_level
FROM sys.databases WHERE name = 'impresario';

Thanks,
David

HI Chris - the question wasn't about SQL Server version, but the database compatibility level. For example, you can be running SQL Server 2016, but have a database set to SQL Server 2014 (120) compatibility level (which is what we are currently using). You can find this value in database properties in the Options section labeled, "Compatibility level". You can also find it via this script:

SELECT compatibility_level
FROM sys.databases WHERE name = 'impresario';

Thanks,
David

David Frederick said:

the question wasn't about SQL Server version, but the database compatibility level.

I understand; we're running SS 2016 compatibility level, a.k.a. 130, as well.

Thanks, Chris. That's good to know. We'll probably shift our test environments to 130 just to confirm nothing weird happens and then shift live over.