VERIFIED SOLUTION i

Confirm - Resolve Mapping - error "CREATE INDEX failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with spatial index operations.

Product Feature: Application Infrastructure

 

Issue

The following error is encountered when trying to run the index creation scripts for the Confirm spatial database installation.

"CREATE INDEX failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with spatial index operations.

 

Cause

This normally means that the set identifier commands are not being committed before the spatial index creation SQL is run.

Resolution

UPDATED: October 20, 2017
Use the following SQL to create the index or run each line separately :

SET QUOTED_IDENTIFIER ON;
GO
CREATE SPATIAL INDEX feature_sx1_sp_geography ON feature (sp_geography) WITH (BOUNDING_BOX = (-180,-90,180,90));
GO
SET QUOTED_IDENTIFIER OFF;
GO