SQL Server Error Msg 6390 – ALTER SCHEMA COLLECTION failed because path ‘%.*ls’ indexed with selective XML index ‘%.*ls’ on table ‘%.*ls’ would be invalidated. Either the schema or the specified path should be altered so that validation does not find any mismatches.

In this blog post, let’s learn about the error message “6390 – ALTER SCHEMA COLLECTION failed because path ‘%.*ls’ indexed with selective XML index ‘%.*ls’ on table ‘%.*ls’ would be invalidated. Either the schema or the specified path should be altered so that validation does not find any mismatches.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

6390 – ALTER SCHEMA COLLECTION failed because path ‘%.*ls’ indexed with selective XML index ‘%.*ls’ on table ‘%.*ls’ would be invalidated. Either the schema or the specified path should be altered so that validation does not find any mismatches.

Reason for the Error

To be update soon…

Solution

To be update soon…