Post reply

XP SMTP

  • August 23, 2010 at 1:22 pm

    #100299

    Hey guys,

    I've developed an automatic emailing solution for my client in SQL Server 2000 using XP SMTP which worked very well. However, recently the client has switched SMTP servers and the emailing no longer seems to work. I gather that the server needs to allow for no authentication, but none of the other options I have in my notes or code point to any other changes I can make to accommodate this new server. Unfortunately, upgrading SQL Server is not really an option, but even if it was, we would need to redevelop an emailing solution rather than using this existing method.

    When searching for more information, the site that contained all of the readme information seems to have been taken offline. Does anyone have reference materials or suggestions as to other things that I can try to make this solution work with a new email server that seems to no longer work with the code below?

    Thanks,

    Kevin

    Here is the code that I've been using:

    declare @rc int

    exec @rc = master.dbo.xp_smtp_sendmail

    @FROM = N'DarthVader@Deathstar.com',

    @FROM_NAME = N'Darth Vader',

    @TO = N'Yoda@Degoba.com; Luke@Tatooine.com',

    @cc = N'Leia@Alderan.com; Chewie@Kasshyk.com',

    @subject = N'Automated Report Delivery - C-Aging (GS)',

    @message = N'<html><FONT face = "Arial" size="2">Hi there,

    Please find your SAP excel report attached.

    Thanks,

    SAP.</FONT>',

    @type = N'text/html',

    @attachments= N'D:\Tryarc\XLExportReports\C-Aging\C-Aging-GS.XLS',

    @server = N'server.DeathStar.com'

    select RC = @rc

    go

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply