Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
summoner
Starting Member
2 Posts |
 Posted - 2008-11-16 : 20:35:09
|
| Dear all,I use "DBCC CHECKDB WITH TABLERESULTS" to retrieve all error message.For some reason, I need to check the error message through program. The result table is confusing me because there is field "error", "state" and "status".Does that state = 1 mean no error, while state <> 1 means errors?Does that status = 0 mean no error?If "repair_level" is not null, is that there must be some errors on that table?In case I would like to count all the errors, which fields should I consider?Thank you very much |
|
|
manujaidka
Starting Member
1 Post |
|
|
|
|
|
DBCC CHECKDB WITH TABLERESULTS