Thank you for reply lowel.

I say:

dbcc checkdb (SandBox) with no_infomsgs does not return any results....so why bother capturing the results in a text file in the first place? maybe it only returns results if there was a problem/failure? {edit} dbcc only returns messages, so no_infomsgs will never return results at all...so there's no need to capture it in both a table and a file...it would be better to not include that i think.{/edit}

Do you say that the DBCC command does not return any results? even if there is a problem with the DB?

What i want is that, if there is a problem with the DB, then the results should be returned but if there are no errors, then no results need to be returned (the file can be created even empty, no prob.)

So if i do DBCC with no_infosmsg will the SQL Server return results if the dabase as an error, or not?

Thank you