When trying to load a .SHP into MSSQLSpatial using OGR2OGR, I get the following error:
ERROR 1: Error initializing the metadata tables : [Microsoft][ODBC SQL Server Dr iver][SQL Server]There is already an object named 'geometry_columns' in the data base.
I can see the entries using this query:
SELECT * FROM giswork.INFORMATION_SCHEMA.COLUMNS where table_name like 'geometry%'
And the result looks like this:
And If I dig deeper with this query:
select * from matthew_baker.geometry_columns
I get a set of empty results:
- What should be in the geometry_columns table (if it's not there already...)
- Why does og2ogr throw the error about the geometry_columns table already being created?
EDIT: It seems that GDAL created these tables when I tried to use the OGR2OGR command - they have not been in my database until now. My current spatial data was created using FME and is updated with FME.
I can view AND edit my MSSQLSpatial tables in QGIS 2.10 without any issues, across multiple schemas in my database.