Recently we faced the following error in our live database of one of our esteem client

Database Error : Unable to find index entry in index ID 1, of table 1360723900, in database ‘Database Name’. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support. A severe error occurred on the current command. The results, if any, should be discarded. in MS SQL Query

Quick Solution to the Error

Firstly I try to find out what it this object it is table or view

select object_name(1360723900)

This query return me the name of object which was indexed view.
Then I try running DBCC CHECKDB (You can try DBCC Checktable for table) to checks the allocation and structural integrity of all the objects in the specified database. I don’t find any error in database allocation or structural integrity. Then I tried to remove all indexes in that view and re-add them back and that worked for us.

• ASP.Net C#
• SQL
• SQL Server
• SQL Tips