I have a SQL Server table with two geometry spatial columns (A, B). I have created two rows in geometry_columns table for both of these.
f_table_catalog f_table_schema f_table_name f_geometry_column coord_dimension srid geometry_type neil dbo Temp_CSVLoad [A] 2 27700 POINT neil dbo Temp_CSVLoad [B] 2 27700 POINT
If I go into QGIS and add a SQL Server layer, it finds and shows me these two layers as choices correctly, but no matter which one I select it only ever plots A, whether I select to add the row linked to column A or column B. If I look at the properties, it is definitely showing the correct column as part of the properties.
If I null column A and only add a layer for B, I get nothing. If I null column B and only add a layer for B, I still get A.
Am I doing something obviously wrong?