Export (0) Print
Expand All

Setting Options (XML Index)

SQL Server 2005

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.

Community Additions

ADD
Show:
© 2014 Microsoft