Different SQL mail  
Author Message
tmgt





PostPosted: Wed Aug 16 05:56:20 CDT 2006 Top

SQL Server >> 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.

tony

SQL Server142  
 
 
Tibor





PostPosted: Wed Aug 16 05:56:20 CDT 2006 Top

SQL Server >> Different SQL mail If 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/



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