Hello Community,
When I run the 3.9 upgrade script (upgrading from 3.8 to 3.9) I get the following errors. Does anyone know what is causing this, and how to fix it?
Thank you,
Shawn
Msg 5074, Level 16, State 1, Line 3178
The index 'nci_wi_Product_FAE5407D-41FA-4FBA-932B-F958B5B39B36' is dependent on column 'SpecialPrice'.
Msg 5074, Level 16, State 1, Line 3178
The index 'nci_wi_Product_E99FFCFADB9BB34A8DDF' is dependent on column 'SpecialPrice'.
Msg 5074, Level 16, State 1, Line 3178
The index 'nci_wi_Product_F47D701CD15593F7F355' is dependent on column 'SpecialPrice'.
Msg 4922, Level 16, State 9, Line 3178
ALTER TABLE DROP COLUMN SpecialPrice failed because one or more objects access this column.
Msg 5074, Level 16, State 1, Line 3185
The index 'nci_wi_Product_FAE5407D-41FA-4FBA-932B-F958B5B39B36' is dependent on column 'SpecialPriceStartDateTimeUtc'.
Msg 4922, Level 16, State 9, Line 3185
ALTER TABLE DROP COLUMN SpecialPriceStartDateTimeUtc failed because one or more objects access this column.
Msg 5074, Level 16, State 1, Line 3192
The index 'nci_wi_Product_FAE5407D-41FA-4FBA-932B-F958B5B39B36' is dependent on column 'SpecialPriceEndDateTimeUtc'.
Msg 4922, Level 16, State 9, Line 3192
ALTER TABLE DROP COLUMN SpecialPriceEndDateTimeUtc failed because one or more objects access this column.
