General discussion

Locked

sql server indexes

By krisdevs ·
when index are corrupted how do we construct it without dropping it through scripts ?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

sql server indexes

by jmiller1 In reply to sql server indexes

You can try to run DBCC DBREINDEX. This command essentially drops and rebuilds the index internally. If this fails to correct your problem, you will need to drop and recreate the index manually.

Collapse -

sql server indexes

by krisdevs In reply to sql server indexes

Poster rated this answer

Collapse -

sql server indexes

by krisdevs In reply to sql server indexes

This question was closed by the author

Back to Networks Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums