Fix SQL statements in the SQL Server database

The reason for these problems is that the database is damaged or the index is incomplete.
In access, there is a function to fix the database to solve this problem. In SQL Enterprise Manager, this function is not available and should be completed using statements, the following describes how to use SQL statements to fix databases. Note that all users must be disconnected during the following operations: CopyCodeThe Code is as follows: use master
Go
Sp_dboption 'your database name', 'single user', 'true'
Go
DBCC checkdb ('your database name', repair_rebuild)
Go
Use your database name
Go
Exec sp_msforeachtable 'dbcc checktable (''? '', Repair_rebuild )'
Go
Sp_dboption 'your database name', 'single user', 'false'
Go