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?

P.C. Vaidyanathan