> my config is SQL2000, outlook xp
>
> now i use xp_sendmail to see email from SQL2k
>
> how can i use different mail profiles for different database?
>
> or i can control it at script level?
>
> i have searched google for this and seems it is feasible.
>
> grateful if you could give me some hints.
>
> by the way, i am going to upgrade SQL2000 to SQL2005.
>
> Thanks a lot.
>
> tony
>