I've just spent the last hour wrestling with a spatial selection problem on an MS SQL Server layer in QGIS 2.14.10. The layer is a point layer and each time I click on a point every point in the layer is selected. It sounded similar to the problem described here:

issues with selection

However, I had no uniqueidentifier data type in my table. What I did have was a VarChar(16) clustered primary key called TaxOcc. Once I removed this key and added an integer clustered primary key called id my spatial table started behaving as expected in QGIS. If I click on a single point using the select tool, only that single point is selected :-). Is this a bug or a feature? Do primary keys in MSSQL Server need to be integers and called id in order for the table to work properly in QGIS? Anyway whichever, hope the above saves someone else some time :-)


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.