SQL Mail

[vaidyanathanpc]

Hi,
I have SQL Server installed on a WINDOWS NT 4.0 server. I am using SQL Mail to send
mails. Is it possible to have two profiles configured to send mails thru SQL Server?
What I mean is, for application1 I want to send mails through profile1 and for another application2 I want to send mails through profile2. Is it possible for me to switch profiles or is it that I can have only one mail profile for a SQL server?

Regards,
P.C. Vaidyanathan

 

[tlbroadbent]

I've never tried it but xp_startmail in SQL 2000 can accept a profile name as a parameter. Check SQL BOL for more info. I don't know if it works. We always use one profile.

In SQL 7, this parameter was called "user" so I don't know if it could use a different profile. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.