Take the 2-minute tour ×

I have a view which already has SchemaBinding applied AND it has a UNIQUE CLUSTERED index.

Now, i'm trying to add a second index, which is a SPATIAL index ... and I get the following error message:-

enter image description here

and here's the a piccy of the schema....

enter image description here

Can someone help, please?

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

FFS - I found my answer.

Spatial Indexes cannot be specified on indexed views.

The error message is incorrect / misleading.

Cheers & Heads up to a previous SO question which is very similar.

Epic Fail again.

enter image description here

enter image description here

share|improve this answer
add comment

Your Answer


