DBCC output

greenspun.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".

Good Luck,


-- Anonymous, December 19, 1999

Moderation questions? read the FAQ