In this blog post, let’s learn about the error message “6395 – The maximum key length is %d bytes. The secondary selective XML index ‘%.*ls’ over path ‘%.*ls’ has maximum length of %d bytes. For some combination of large values, the insert/update operation will fail.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
6395 – The maximum key length is %d bytes. The secondary selective XML index ‘%.*ls’ over path ‘%.*ls’ has maximum length of %d bytes. For some combination of large values, the insert/update operation will fail.
Reason for the Error
To be update soon…
Solution
To be update soon…