|
3> CREATE TABLE dbo.VisioDocs
4> (
5> id INT NOT NULL,
6> doc XML NOT NULL
7> );
8> GO
1>
2>
3> ALTER TABLE dbo.VisioDocs
4> ADD CONSTRAINT PK_VisioDocs PRIMARY KEY CLUSTERED (id);
5> GO
1> CREATE PRIMARY XML INDEX idx_xml_primary ON dbo.VisioDocs(doc);
2> GO
Msg 1934, Level 16, State 1, Server J\SQLEXPRESS, Line 1
CREATE XML INDEX failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed column
s and/or query notifications and/or xml data type methods.
1> CREATE XML INDEX idx_xml_path ON VisioDocs(doc)
2> USING XML INDEX idx_xml_primary
3> FOR PATH;
4> GO
Msg 1934, Level 16, State 1, Server J\SQLEXPRESS, Line 1
CREATE XML INDEX failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed column
s and/or query notifications and/or xml data type methods.
1>
2> drop table VisioDocs;
3> GO
|