First off, I'm using SQL Server 2008 R2.
When I set up my maintenance plan and got to the "Select Report Options" step, I selected to email the report to the Operator I already have set up. This does not allow me to alter the subject, which I believe Gmail uses when it collapses emails into conversations.
Is there a way to trick Gmail to separating them out based on the database? Or is there a better way from within SQL Server Management Studio to email the reports out? I have multiple instances, with their own Operator, each Operator is using the same email address (no_reply@noneofyourbusiness.com), but the name is different….but since the subject is the same, Gmail still collapses them into one big conversation.
Does anyone else have to deal with this issue?
Best Answer
The easiest way would be to send the email with differing subject lines. If you just want different database in different conversations make sure the database name is included in the subject line. If you want a new conversation for each email sent, include a timestamp in the subject line.