Home Dashboard Directory Help
Search

XML schema collection does not script properly by Michael Hotek


Status: 

Closed


1
0
Sign in
to vote
Type: Bug
ID: 779860
Opened: 2/22/2013 9:38:32 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

XML schema collections script out using SQL Server types, even if the schema collection was created using native XML types. This wasn't an issue before selective XML indexes were introduced which do not support schema collections with SQL Server types. That means while I can create the schema collection using native types, it becomes impossible to script out the schema collection and run the resulting script such that you can create the selective XML index which was there before.
Details
Sign in to post a comment.
Posted by Microsoft on 3/28/2013 at 12:27 PM
Hello

We took a look at this bug along with several others recently.
Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future.
However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.

Thanks for writing in to Microsoft.
Alex Grach[MSFT]
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
Selective XML index bug.sql 2/22/2013 3 KB