SQL Server State: 42000-5074 and SQL State: 42000-4922

I am encountering an app issue after I manually updated all the columns to UPPER CASE.

Error: SQL State: 42000-5074

Message: [Microsoft][ODBC SQL Server Driver][SQL Server]

The index 'OBJECTREVM14F63D20A' is dependent on column 'FILE_NAME'.

Error: SQL State: 42000-4922

Message: [Microsoft][ODBC SQL Server Driver][SQL Server]

ALTER TABLE ALTER COLUMN FILE_NAME failed because one or more objects access this column.

What does it mean? There was only one app running on the database so I开发者_JAVA技巧 am totally confused.

---

You have an index that uses the columns. SQL Server doesn't allow changes to columns that have indexes or constraints on them

The name is in the message: sse SSMS Object Explorer to find this index

The index 'OBJECTREVM14F63D20A' ...

Or use

sp_help 'Mytable'