I think I've fixed the line & title problem. Could you take a check?

I'll work on the image to the left when I have a breather (wrote 20-30k worth of...

Actually, it occurs to me to wonder if you have a link in some other table from UserID to UserName?

If UserName is not in any of the three tables...

I don't mean to offend anyone but...

Why does everyone insist on putting this check in the WHERE clause? It's messy and a Where clause usually complains when you try and...

Just an FYI. If using a variable is not an option because you're trying to do a set based conversion, then you can always use a CASE statement with a...

There is another option, though a very old option and not very pretty. Only use this if you can't convince the designers to use 2 separate columns in the main...

DOH!

I went back and checked our accounts after reading the Microsoft fix bulletin. Sure enough, different ReplyTo addresses than what's in the account name.

Fixed that and it still didn't work....

Nope. The SQL Agent Service restart didn't help me.

Darnit. This is annoying.

Well, we'll see if the restart works. I won't know until Monday.

Truthfully, though, I doubt this will solve my problem. We've failed over our cluster a number times since this...

Looking into this a little more, I finally opened up my job log and found the following error:

Files NOT Uploaded. Reason: System.Net.WebException: The remote server returned an error: (501) Syntax...

I did, but my other office (different state from me) says they can't find the files.

Are you using IP & Port # for your FTP or just IP address?

Okay, I haven't tested this yet, but something about it just doesn't seem right. I've take the Upload code based on the website listed above and I have a Server...

Jack,

Do you know what the ReplyTo problem was? Or at least a good search term for me to find the problem?

Paresh,

Have you actually looked at the Books Online explaination of that proc?

Sorry, but you can't accomplish what you're trying to accomplish using SQL Server straight out of the box. If...

Jack,

We don't usually use the ReplyTo functionality of the DatabaseMail. Most of our stuff is general DBA Team alerts on failed jobs (non-repliable emails).

Rcavill, Yes, the procs were enabled...