How can I create a Spatial Index on an Indexed View?
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:-
And here's the a picture of the schema:
Solution
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.
- How to see how many column(a) values are for each column(b) in SQL
- SQL Server: Login failed for user
- 1 column to 1 row
- Using DATEADD with bigints
- How do I get date/time information from a TIMESTAMP column?
- Is it possible to disable the 'shift+space' shortcut in SQL Server Management Studio 2008?
- How to find SQL Server running port?
- Concerning Deprecated features (More than two-part column name)
- SQL Server: how to get a database name as a parameter in a stored procedure
- Split call data to 15 minute intervals
- Sql Server Network Configuration Protocols Not Available
- What is best approach for auto increment?
- How to avoid duplicate values in SQL Server
- SQL Server - Return value after INSERT
- How eliminate the tab space in the column in SQL Server 2008
- Is it faster to UPDATE a row, or to DELETE it and INSERT a new one?
- How can I create a unique constraint on my column (SQL Server 2008 R2)?
- Create user that can only SEE one database, and only select from it?
- Copy data into another table
- sql query to return differences between two tables
- How can I add a new schema to SQL Server 2008?
- Checking an input param if not Null and using it in where
- SQL Multiple Filter - Optimal Way
- SQL Server - Order by name from Subquery
- Why is there no `select last` or `select bottom` in SQL Server like there is `select top`?
- QUALIFY-Like Function in SQL Server
- Find broken objects in SQL Server
- Find all integer gaps in SQL
- SQL Server : get average per week for the past 30 weeks
- Transfer data from one database to another database