I recently moved from QGIS 2.2 to 2.4.0 and in the process the MSSQL spatial data provider appears to have stopped working properly (behaviour is also the same with 2.5.0).
QGIS will still connect to an MSSQL table and will display the geometry, however it is not possible to filter it with a query, the SRID is not being read from the geometry_columns
table and more importantly it is not possible to commit any edits back to the database.
I am running SQL Server 2012 - the geometry_columns
table is present and populated correctly and all tables have integer primary key columns, etc.
Has anyone else encountered this problem? I am a bit perplexed as I have never experienced any problems prior to updating to 2.4.0.