Check xp_startmail and xp_stopmail extended stored procedure. Keep in mind that using them will affect anything using SQL Mail.


>Hi friends!
>
>I need to send some emails to certain users with a different mail profile than the default. What can I do to change the default mail profile to another (already configured) and then change it back to the default after sending those emails?
>
>Any help would be appreciated.
>
>TIA
>
>Renzo