Setting Options (XML Index)
When you create an XML index on the xml type column or when rebuilding an XML index, the following options must be set as shown.
| SET Options | Required Values |
|---|---|
ANSI_NULLS |
ON |
ANSI_PADDING |
ON |
ANSI_WARNINGS |
ON |
ARITHABORT |
ON |
CONCAT_NULL_YIELDS_NULL |
ON |
NUMERIC_ROUNDABORT |
OFF |
QUOTED_IDENTIFIER |
ON |
If the options are not set as shown, you will not be able to create an XML index. Also, you will not be able to insert or modify XML values in an XML column on which an XML index has been created.
See Also
Concepts
SET Options That Affect Results
Sample XML Applications