Blog Post

Azure Database Support Blog
4 MIN READ

Getting Error 666 when creating non-clustered index- Msg 666, Level 16, State 2, Line 25

Tancy's avatar
Tancy
Icon for Microsoft rankMicrosoft
Nov 11, 2022
Issue A backend compatibility issue was encountered recently when the creation of a non-clustered index on a partitioned table of a hyper-scale Azure SQL DB failed with the error 666. The table in ...
Published Nov 11, 2022
Version 1.0
divineinteriors65's avatar
divineinteriors65
Copper Contributor
Jun 07, 2024

The article provides practical solutions like switching to compatibility level 160 and making index creation online and resumable to handle large tables efficiently. For those looking to upgrade their home fixtures, check out a wide range of kitchen and bathroom taps at  https://tapron.co.uk/