I try to change a collation on column FirstName on table Person. Then I got following error:
Msg 5074, Level 16, State 1, Line 1
The index 'IX_...' is dependent on column 'FirstName'.
Msg 4922, Level 16, State 9, Line 1
ALTER TABLE ALTER COLUMN FirstName failed because one or more objects access this column.
So should I drop the index before the change and create it again after the change? Any other possible impact on existing data for such kind of change?
View Complete Post