Dear Eric, Is there's any way I can write an output of DBCC CHAECKTABLE or DBCC CHECKDB to the text file and email it. I appreciate any help. Thanks

Albert

-- Anonymous, December 15, 1999

Answers

Albert,

You can do this using the xp_sendmail extended stored procedure. First, however you will have to start the mail process with xp_startmail. Before this you may want to check out the SQL Server Books Online article, "Setting Up SQLAgentMail".

Good Luck,

Eric

-- Anonymous, December 19, 1999