Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
Msg 5074, Level 16, State 1, Server <Servername>, Line 19
The index 'IX_SCA_CELL_LOGIN_DeviceUD_CommonCookieNonce' is dependent on column 'CommoncookieNonce'
Msg 5074, Level 16, State 9, Server <Servername>, Line 19
ALTER TABLE ALTER COLUMN CommonCookieNonce failed because one or more objects access this column

How can I fix it?

In order to To fix it, we need to remove the constraint from the table do the upgrade and then reinsert the constraint.

...