January 12, 2005 at 7:59 am
I run DBCC CHECKDB ('dbname') with ALL_ERRORMSGS as a scheduled job within Enterprise Manager. I get a final message in the SQL log (no errors found, which is a great thing). If I view the history of the job, I get several rows of messages but not all. If I run this in QA, I get all the messages. Where are the messages? Or, how do I get them to either log or sent to a file that can be opened later? Thanks for any help that you can provide.
Terry
January 12, 2005 at 9:44 am
use with_tableresults and put the results in a table for later viewing.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
January 12, 2005 at 9:49 am
Steve, is this an undocumented function? I don't see anything in BOL. I'll play around with it. Thanks for the tip.
Terry
January 13, 2005 at 3:01 am
i'm sure this is documented in BOL? we've used this method for over a year now and it sure makes things easier to examine long term.
January 13, 2005 at 7:06 am
Can anybody offer the syntax? I've tried several things and even searched Microsoft without any success. Thanks.
Terry
January 13, 2005 at 8:18 am
dbcc checkdb (DBNAME) with tableresults
it's a simple as that.
Also, i found the place that i'd seen it, it's hidden away in the DBCC SHOWCONTIG bit of BOL, so i guess you're right it is undocumented for this DBCC command after all
January 13, 2005 at 8:35 am
Mike, where does it put the results? Simply to the log?
Terry
January 13, 2005 at 3:24 pm
as an alternative you can specify in the job step:Advanced->Output File(create output file on the local drive) with Overwite or Append. It saves all output (which you see in QA) to the text file, which you can send to your developers...
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply