I have a question on index
Our Application is throwing the following SQL error
Index 'INDEXNAME' on table 'dbo.TABLENAME' (specified in the FROM clause) does not exist. Error: Unknown Error Errorcode: 308
But when I queried the DMV I am able to see the index. Also, a particular column is used in two different non clustered indexes, is this a valid set up? Any suggestions to fix this issue.
I appreciate your help.