DBCC outputgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
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
-- Anonymous, December 15, 1999
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".
-- Anonymous, December 19, 1999