sys.sp_db_selective_xml_index

Description

Enables and disables selective XML index (SXI) functionality on a SQL Server database. If called without any parameters, the stored procedure returns if SXI is enabled on a particular The name of the database on which to to enable or disable selective XML index. , the current database is assumed. Determines whether to enable or disable the index. , and can be one of the following values:

Syntax

sp_db_selective_xml_index
[ [ @dbname = ]
N
'dbname'
]
[ , [ @selective_xml_index = ]
'selective_xml_index'
]
[ ; ]