Help with smtp mail
-
Hello
I would like to know if we are using the SMTP mail, is it still required to have an outlook on the sql server box.
Thanks
-
If you are using SQL 2005 than you do not need to use another thing. But if you are using SQL 2000 you need to use some extended stored procedure (xp_smtpsendmail for instance), or Outlook to use exchange mails.
Zubeyir
-
In 2000 SMTP mail does not require outlook.
exec @rc = master.dbo.xp_smtp_sendmail
@from
= @EmailFromAddress
, @from_name = @EmailFromName
, @to = @Recipients
, @replyto = @ReplyToAddress
, @cc = @CCRecipients
, @bcc = @BCCRecipients
, @priority = @Priority
, @subject = @Subject
, @message = @Message
, @attachments = @Attachments
, @messagefile = @Messagefile
, @server = @MailHost
A.J.
DBA with an attitude -
xp_smtp_sendmail can be found at
http://www.sqldev.net/xp/xpsmtp.htm
I have found this program also very useful.
http://www.dimac.net/default2.asp?M=Products/MenuCOM.asp&P=Products/w3JMail/start.htm
-
To my understanding under the properties screen for SQL Server 2000 SP4 you should see a change button to change the mail server that is being used. This is for SQL Mail under the Server Settings page on the properties screen. Mine is just greyed out and there is no button to click on to change the mail server from nothing to something. Basically this stops the ability of SQL Server to send any notifications email or not start the SQL Server Mail Agent due to nothing being specified. Any suggestions would be greatly appreciated.
-
Sorry about that, did not mean to actually quote the last responder to this post.
-
The SQL instance must run with the same account that is set up for sending mails. Then it appears where you need it.
Zubeyir.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply