No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

FAQ-How to Use Database Check Tool DBCC

Publication Date:  2012-07-25 Views:  12 Downloads:  0
Issue Description
Q:
How to use database check tool DBCC?
Alarm Information
Null
Handling Process
A:
1.check the database wrong information
1>dbcc checkdb(database_name)
2>go
It will show all of the tables information and wrong information.
2.check the tables wrong information
1>dbcc checktable(table_name)
2>go
It will show the check result of this table and wrong information.
3.restore the index command
1>dbcc reindex(table_name)
2>go
All index of this table will be built automaticly. 
Root Cause
Null
Suggestions
Null

END