*bump* Anyone have any ideas here?

That was classic cppwiz. :smooooth:

Actually, after plugging these two solutions into the actual database that have proper indexes, the optimization goes the other direction. 44% for arjun solution and 56% for ramesh solution....

I appreciate the replies. Ramesh, I realized after posting that I should have included sample data, but thought that with the amount of information there, it really would come...

SQL-KV (5/8/2009)

---

Dear All,

Me tooo having the same issue....

Message

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2009-05-08T14:12:29). Exception Message:...

I changed your creation script so you can see that the script here is working correctly. Give it a shot, this should work for you.

The main problem you are...

You should be able to do this without any issues. They both support log shipping. The only thing to consider is if you need to have other software...

The purpose of that option is...

Is it sending out to a distribution group and not an actual mailbox?

Vampire (4/9/2009)

---

@Sayfrend,

1) I have checked and Broker Service is enabled for my MSDB,

2) About Port 25 :let me put a fact here.. I have other mail profiles configured...

You could try using the Microsoft Network Monitor to check if the connections are being opened from SQL, if traffic is getting out and not getting back, etc.

http://www.microsoft.com/downloads/details.aspx?familyid=f4db40af-1e08-4a21-a26b-ec2f4dc4190d&displaylang=en - Download

http://support.microsoft.com/kb/148942...

Vampire (4/8/2009)

---

@tnolan

Below is the output of the query:

Sorry that i couldn't post the query results as a grid, but i did my best to ensure its readability.

I have...

Final thought... make sure your anti-virus software is not blocking port 25 from going out. Any mail filtering configured in AV might interfere with this functionality. Symantec, AVG,...

It looks like something is still blocking your traffic. Google does not block ICMP to SMTP.GMAIL.COM so you should be getting a response back from that server. The...

That is pretty amusing. Apparently the QC process for BOL is not entirely thorough. 😉 Thanks for clearing that up though, good to know even BOL can't always be...