Nonclustered indexes

by Info23   Last Updated April 28, 2017 11:06 AM

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.

Related Questions

SSIS Package Deployment Failure using SSDT

Updated May 27, 2015 04:02 AM

Report Builder cannot publish to report server

Updated June 04, 2015 01:02 AM