Different SQL mail

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.
tonyHi
xp_startmail will take a different MAPI profile. You may want to use XPSMTP
instead where the source can be specified [url]http://www.sqldev.net/xp/xpsmtp.htm[/url
]
John
"Tony WONG" wrote:

> 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
>
>