John, thanks a lot. I didn't think it was going to work for creditor 129 because the mask has numbers after the '#' also, but it works fine. The Mask...

Already tried that one. Nothing

It DIDN'T work. We tried changing to lower case, upper case, even login in with different users with no upper/lower case difference but NONE worked.

So we tried a different approach....

Checking our accounts setup I noticed that we are using different caps on the names. Some are small caps, some not. So we made the adjustments and we will try...

Yes to both questions. Actually we had no problems sending any emails previously, up until we applied SP4. Every job was running smoothy, every xp_sendmail was sending emails.

I guess the reporting services option should be one to consider.

The idea of using xp_sendmail and send the crystal as an attachment would be good if I could make...

OLTP with Visual Studio applications running against it. A lot of data modification happening. About 120 users changing data.

I had to make some changes to the trigger to make it work but now I am getting the name of the trigger instead of the stored procedure that made...