There was one thing missing in the implementation of 2005 database mail: Dynamic Profiles.

The company I work for sends lots of email on behalf of our reseller customers (impersonating them).

It took a ton of work to figure out how to do this and to supress some of the errors that were raised.

There was also some big security settings that needed to be figured out before I could implement this functionality.

since I can't attach the scripts directly, I'll add seperate posts for the steps involved.