Cannot create secondary xml index '%.*ls' without a USING XML INDEX clause.

Error Message:
Msg 6343, Level 15, State 1, Line 2
Cannot create secondary xml index ‘%.*ls’ without a USING XML INDEX clause.

Severity level:
15.

Description:
This error message appears when you try to create a XML index without the mandantory USING XML INDEX clause.

Consequences:
The SQL statement cannot be parsed and further execution is stopped.

Resolution:
Errors of the Severity Level 15 are generated by the user and can be fixed by the SQL Server user. The statement cannot be executed this way. In order to create a secondary XML index you must specify the USING XML INDEX clause in the CREATE XML INDEX statement.

Versions:
This error message was introduced with SQL Server 2005.

Example(s):
USE tempdb;
GO
IF OBJECT_ID(‘tempdb..#t’) > 0
 DROP TABLE #t
GO
CREATE TABLE #t
(
 id INT PRIMARY KEY,
 c1 XML
)
GO
CREATE PRIMARY XML INDEX IX_XML_t_c1
    ON #t(c1);
GO
CREATE XML INDEX IX_sXML_t_c1
    ON #t(c1)

Remarks:
In the above example we try to create a secondary XML index on the column c1 of the table #t. Because we have omitted the mandatory USING XML INDEX clause, the error is raised.

]]>

Leave a comment

Your email address will not be published.