sp_db_selective_xml_index (Transact-SQL)
Applies to:
SQL Server
Enables and disables selective XML index (SXI) functionality on a SQL Server database. If called without any parameters, the stored procedure returns 1
if SXI is enabled on a particular database.
Note
In SQL Server 2014 (12.x) and later versions, the SXI functionality can't be disabled. This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Transact-SQL syntax conventions
Syntax
sp_db_selective_xml_index
[ [ @dbname = ] N'dbname' ]
[ , [ @selective_xml_index = ] 'selective_xml_index' ]
[ ; ]
Arguments
[ @dbname = ] N'dbname'
The name of the database on which to to enable or disable selective XML index. @dbname is sysname, with a default of NULL
.
If @dbname is NULL
, the current database is assumed.
[ @selective_xml_index = ] 'selective_xml_index'
Determines whether to enable or disable the index. @selective_xml_index is varchar(6), with a default of NULL
, and can be one of the following values: ON
, OFF
, TRUE
, or FALSE
. Any other value raises an error.
Return code values
1
if the SXI is enabled on a particular database, 0
if disabled.
Examples
A. Enable selective XML index functionality
The following example enables SXI on the current database.
EXEC sys.sp_db_selective_xml_index
@dbname = NULL
, @selective_xml_index = N'on';
GO
The following example enables SXI on the AdventureWorks2022
database.
EXECUTE sys.sp_db_selective_xml_index
@dbname = N'AdventureWorks2022'
, @selective_xml_index = N'true';
GO
B. Disable selective XML index functionality
The following example disables SXI on the current database.
EXECUTE sys.sp_db_selective_xml_index
@dbname = NULL
, @selective_xml_index = N'off';
GO
The following example disables SXI on the AdventureWorks2022
database.
EXECUTE sys.sp_db_selective_xml_index
@dbname = N'AdventureWorks2022'
, @selective_xml_index = N'false';
GO
C. Detect if selective XML index is enabled
The following example detects if SXI is enabled, and returns 1
if SXI is enabled.
EXECUTE sys.sp_db_selective_xml_index;
GO
Related content
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho