开发者

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

开发者 https://www.devze.com 2023-02-17 13:15 出处:网络
I am encountering an app issue after I manually updated all the columns to UPPER CASE. Error: SQL State: 42000-5074

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'
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号