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 |
|
JamesH
Posting Yak Master
149 Posts |
 Posted - 2005-04-22 : 08:11:36
|
| Hey all,Long time since I've been here... Been busy on other things. Anyway, I'm working on a simple DBCC reader application to hand off to some helpdesk people that allows them to interpret the DBCC CHECKDB WITH TABLERESULTS so they don't have to bother me in the middle of the night unless it's a major problem (errorcode <> 2593 or 8989) . Other than looking for individual err codes is there a listing for all possible DBCC results (CheckDB).Many thanks,Jamesh |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-04-22 : 15:53:10
|
| I'm not sure where you'd find a listing. Why not just setup a job to do the DBCC CHECKDB then page the DBA on error of the job? For any failure of the job, I'd want to be paged immediately. I wouldn't want to ignore any problems with this job as if your database is fine, the job will be successful.Tara |
 |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2005-04-25 : 08:44:27
|
| Sorry,I should have been more specific. These results are sent from customer sites and are not internal to us. We usually only have dial-up access to the sites but have technicians that physically visit the sites and gather information for the helpdesk and engineers. My application (2 part) 1. creates an xml file of the dbcc results and then compresses it so it can be sent over dial-up quickly 2.has a reader on our end that physically highlights any problems (the first line of support has no experience with SQL Server). I want to add a 3rd part which will give a better explanation of any errors returned by the checkdb. I'm currently highlighting anything other than 2593 and 8989 as well as any text in the datagrid that contains 'err'.Thanks,JamesH. |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-25 : 14:53:05
|
| What do you mean by better explanation? Can you use the sysmessages table? |
|
|
|
|
|
|
DBCC Results