Collation change -> filtered indexes ignored

anke.jager

When the collation of some columns changes, all of the (unique) indexes they are used in, are dropped and recreated, except for the filtered (unique) indexes. These indexes seem to be ignored, resulting in an error during deployment:

Msg 5074, Level 16, State 1, Line 166
The index '<index_name>' is dependent on column '<column_name>'.
Msg 4922, Level 16, State 9, Line 166
ALTER TABLE ALTER COLUMN <column_name> failed because one or more objects access this column.

I have SQL Compare 12.0.33.3389 installed.

Rob C

Hi Anke,

I've tried to replicate this with the latest frequent update version (12.0.39.3632) and it seems to be working correctly for me. Can you give this version a try and let me know if it has fixed the problem for you? Here's a download link if you need it - ftp://support.red-gate.com/patches/SQLC ... 9.3632.exe