I use SQL Server 2017, It is possible to recover a dropped index from table?
Someone at my work dropped it and now I get the following error when I try to do a select in the table.
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I tried to create a new index but I get the same error
1条答案
按热度按时间y53ybaqx1#
A dropped index should not result in that error. A dropped index should - at worst - just affect your query's performance.
Do you have a DBA for the SQL Server? I'd recommend contacting them and sharing the error with them, as there's something more serious going on that needs attention.
This error indicates some manner of corruption (maybe the index is corrupted, not dropped), and a DBA can run
DBCCto check for that.