Does anyone know if there are any issues for QGIS in accessing MS SQL Server 2016? I am currently using 2008, but there are a number of new functions within 2016 that are attractive for the upgrade.
We setup a test environment with SQL Server 2017 and QGIS 3.4.8 and found that any issues we had with views were resolved in 2017. We found a lot of benefits with using the temporal tables feature but there are some issues with adding new features to a table with QGIS that we are still working through. It appears to be related to creating a new ID for the row, but we are working on using a stored procedure to resolve this.