October 22, 2002 at 2:52 pm
RE: SQL Server 2k
I am trying to set up a second profile that sqlMail will use to shoot emails out to people.
I have set up the 2nd profile in outlook.
We have a default profile already.
The following code sends mail successfully from my 2nd profile on my 2000 / sql2k box but sends mail from the default profile from my NT / 7.0 box.
--------------------------------------
exec master.dbo.xp_stopmail
exec master.dbo.xp_startmail '2nd profile'
exec master.dbo.xp_sendmail
@recipients= 'xxx@xxxx.com',
@subject = 'Test from 2nd Profile',
@message = 'This is only a Test'
--------------------------------------
Are there any known problems when sending mail from a second profile in NT?
Also it should fail and produce an error when you perform xp_startmail 'sdkjfha' with a garbage profile, but it always succeeds for me....???
Thanks in advance to any insight.
October 28, 2002 at 12:00 pm
This was removed by the editor as SPAM
October 28, 2002 at 6:03 pm
Never tried it. Curious why you need to do this? I know thats not helping much!
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply