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.
tonyIf you upgrade to 2005, consider using Database Mail instead. See sp_send_dbmail in the 2005
documentation.
As for 2000, I believe that you optionally can use different profiles, although I've never tried it.
See the documentation for xp_startmail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tony WONG" <x34@.hknet.com> wrote in message news:enyZScRwGHA.1272@.TK2MSFTNGP05.phx.gbl...
> 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
>