SSMS won't let me create spatial index in SQL Server 2012 -


i have created spatial index on table foo, working properly, , i'm trying create identical spatial index on table bar.

table bar: id int pk autoincrement, geo geography, lat float, lon float, someothervalue int 

the table contains values this:

1   0xe6100000010cd8614cfa7baf45400aa2ee0390f153c0  43.370971   -79.774415  123456 

the tesselationscheme in spatial index on foo.geo geography grid. cells per object 64. granularity set high each of 4 grid levels. trying exact same thing table bar. getting error:

either object or 1 of properties not supported on target server version. 

for help, click: http://go.microsoft.com/fwlink?prodname=microsoft+sql+server&prodver=11.0.2100.60+((sql11_rtm).120210-1917+)&evtsrc=microsoft.sqlserver.management.smo.exceptiontemplates.failedoperationexceptiontext&evtid=create+index&linkid=20476

but page @ microsoft.com has no info.


Comments