1

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.

Improve this question
9
  • Can you post the error exactly it is coming. Your question is not clear – Shanky Dec 3 '14 at 18:58
  • The error message thrown is : Index 'INDEXNAME' on table 'dbo.TABLENAME' (specified in the FROM clause) does not exist. Error: Unknown Error Errorcode: 308 – Info23 Dec 3 '14 at 19:07
  • 1
    Looks like you are using an index hint in a query. Do you really need that? Is the hint on the same table that the index is on? – Mikael Eriksson Dec 3 '14 at 19:20
  • 2
    Any chance the database is case sensitive and the index is IndexName while the error is INDEXNAME? – Kenneth Fisher Dec 3 '14 at 21:56
  • 1
    can you post your entire select statement? – Racer SQL Apr 28 '17 at 12:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.