It was not my intent to use CDONTS as an alternative.

I just wanted to see if it worked.

Thanks.

Lowell,

Sorry that I created a new post. I could not find the original. So I'm wrong for that but I'm not lying.

Yes, it is the same Server and it is...

Jared,

All of the Logins are intact.

As far as I recall I had this issue before I ever changed a Server via services or the configuration manager.

If I went into Services...

SQLKnowItAll (4/2/2012)

---

Looks to me like a permissions issue based on the error messages. Did you restart the service after you changed the login using SQL Server Configuration Manager? (Also,...

Lowell,

I'm sorry. I don't know where I got unsent but the sent_status is 'unsent'

SELECT *

FROM sysmail_event_log

Nothing but start & stop DB Mail

SELECT *

FROM sysmail_allitems

I found the items were listed as failed.

So I check the Windows Event Log...

SQLKnowItAll (4/2/2012)

---

Welsh Corgi (4/2/2012)

---

I changed the Account for the SQL Server and SQL Server Agent Account to an account that it should work with and tried to send a message...

I changed the Account for the SQL Server and SQL Server Agent Account to an account that it should work with and tried to send a message but all of...

No but that makes think that...

I execute the EXEC sp_WhoIsActive and I see that there are 10 concurrent merges on the same table based on the range on the primary key.

Apparently the table loads faster...

:crying:No bites.

No error.

It was modified.

Yes, I...

I have used ERwin and it's not too bad.

I starting to believe that it is a Windows Problem since CDONTS Fails?

I'm using SQL Server 2008 R2 x64 on Windows Server 2008 R2 x64.