Viewing 15 posts - 1 through 15 (of 52 total)
Did you set @Replace to true (SET @Replace = 1)?
January 27, 2014 at 7:41 am
You must remove 'sysadmin' server role from the login you use
May 18, 2011 at 1:15 pm
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...
May 6, 2011 at 12:56 pm
Not yet. An upgrade is scheduled and then I'll observe what happens.
May 4, 2011 at 8:50 am
Here is what I have now:
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...
April 27, 2011 at 9:01 am
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...
April 26, 2011 at 11:33 am
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....
April 26, 2011 at 10:22 am
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...
April 25, 2011 at 3:49 pm
Thank you Shaiju
April 6, 2011 at 2:17 pm
June 10, 2010 at 9:21 am
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:
July 20, 2009 at 11:25 am
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...
July 20, 2009 at 11:03 am
I do have anti-virus in the SQL Server.
SQL Server is able to send small emails but not big ones.
July 20, 2009 at 10:08 am
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?
July 20, 2009 at 9:40 am
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.
July 10, 2009 at 11:30 am