Did you set @Replace to true (SET @Replace = 1)?

You must remove 'sysadmin' server role from the login you use

I never really found the problem but I worked around it.

When using sp_send_dbmail ...... @query='select whatever you want to send',

for some reason that I didn't figure out, the attachment created...

Not yet. An upgrade is scheduled and then I'll observe what happens.

Here is what I have now:

Principal:

Microsoft SQL Server 2005 - 9.00.3042.00 (X64)

Feb 10 2007 00:59:02

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service...

Good points, GilaMonster, My case was different, since I was able to query both databases.

About the other commentary: "This is only documented in cases where there is no witness. Not...

Thank you for all your answers. I'm analyzing each one.

About Robert's question: "Could you have been hit by this bug: http://support.microsoft.com/default.aspx?scid=kb;EN-US;983500"

Yes, that seems to be the same problem....

Here is what happened: we had Principal, mirror and witness setup for one database.

Before the split-brain:

- In Machine 1, we had DatabaseName (Principal, Synchronized)

- In Machine 2, we...

Thank you Shaiju

Thanks Ray

I tried both: Sending the query result as attachment and sending as part of email body.

They both raise the error.

I'm begining to think this may be harder than I thought.:w00t:

I have tested sending to some of my personal email accounts (yahoo, hotmail, etc). None of them are full.

When I execute msdb.dbo.sp_send_dbmail proc, SSMS says "Mail queued" and SQl Mail...

I do have anti-virus in the SQL Server.

SQL Server is able to send small emails but not big ones.

Email server seems to be ok. It accepts 10MB attachments. But I can't send a 50k file using SQL Server mail.

Any other suggestions?

Thanks.

They are not regular users. They are new developers and made some mistakes. The same mistake that a DBA can make. So I'm just exploring alternatives.

All suggestions here are welcome.

Luiz.