Hi to all, In SQL Server 2008 r2 I configured a weekly Maintenance Plan that sends a report to an email recipient and it work fine, but I saw that in the mail also contains query statements of each task. How I can configure the report without the query statements (like typical SQL Server 2005 report log) ? Stefano Pozzuto

Hi Stefano, Can you post a picture of how the report looks like? Also can you share a tad more re your setup?Arthur My Blog

EX1) SQL2005 Back Up Database (Full) (MY_OLD_SERVER) Backup Database on Local server connection Databases: MY_DATABASE Type: Full Append existing Task start: 2011-11-30T02:00:04. Task end: 2011-11-30T02:00:11. Success EX2) SQL2008 Back Up Database (Full) (MY_NEW_SERVER) Backup Database on Local server connection Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped. Databases: MY_DATABASE Type: Full Append existing Task start: 2011-11-30T00:00:01. Task end: 2011-11-30T00:00:06. Success Command:BACKUP DATABASE [MY_DATABASE] TO DISK = N''E:\BackupAutomatici\MY_DATABASE_backup_2011_11_30_000001_5313438.bak'' WITH NOFORMAT, NOINIT, NAME = N''MY_DATABASE_backup_2011_11_30_000001_5313438'', SKIP, REWIND, NOUNLOAD, STATS = 10 GO In SQL Server 2008 there are more information than SQL Server 2005: now exists the line "Command" that contains all query of the related task. In this days I saw in Maintenance Plans's "Reporting & Logging" options a flag named "Log extended information" that if it's unflagged the final report will appear like this one: Back Up Database (Full) (MY_NEW_SERVER) Task start: 2011-11-30T09:34:15. Task end: 2011-11-30T09:34:37. Success By this way I think that I can consider my problem resolved, but (I'm curious) I would know if it is possible (I suppose no) choose to hide only the "Command" line information. Thanks Stefano Pozzuto