Sending error report via E-Mail

  • Hi,

    I need to know the requites off SQl Server (configuration on server side) to implement the send email task.

    Thanks,

    Vítor

  • Why can't i change the "MessageText" propertie in SendMailTask using an ActiveX, it sais that attribute or method does not exist.

    Thanks, Vítor

  • You need to establish SQL Mail first before SQL Server could send an email. Refer to BOL for step by step instruction

    But you must make sure that user account used to run SQL Server and SQL Server Agent services is a domain user account ( do not use a local system account)  

  • A bit of your script here might help us help you

     

    --------------------
    Colt 45 - the original point and click interface

  • Also, you need to have account created with a mail client compatibile with Exchange server (Microsoft Outlook, for example).

Viewing 5 posts - 1 through 4 (of 4 total)

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