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

Help and Information

Getting SQL Server 2005 Assistance