You must Sign In to post a response.
  • Category: SQL Server

    Sending mail from sql server


    Are you looking for information on mail sending functionality? Want to know how to send mail from sql server? Read this thread to learn more about mail sending functionality with examples.



    I configured the database mail on Sql Server 2005 for sending email notifications, but getting this error.

    Exception Type: System.NullReferenceException
    Message: Object reference not set to an instance of an object.
    Data: System.Collections.ListDictionaryInternal
    TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32)
    HelpLink: NULL
    Source: DatabaseMailEngine
  • #719802
    Hi ramadevi,

    I don't no this cause. But in your description it showing "object Reference not set to an instance to an object". This means if you are refering object there is no data in that..

    I think that's the reason its showing this error.
    Can you please check it the assigned object having data or not.

    Hope it will helps you..

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

  • #719808
    Hi Ramadevi.
    You need to ensure that database mail option is on.
    Secondly, make sure that the port 25 is open.

    Thanks

    Reena

  • #719833
    Hi,
    This seems to be a known issue and there is a KB article in Microsoft support site. Please refer the article and make necessary modification/installation.
    support.microsoft.com/kb/2008286


    Regards,
    Asheej T K

  • #719846
    you can below link check:

    i hope to usefull


    http://www.datasprings.com/resources/articles-information/creating-email-triggers-in-sql-server-2005

    http://www.databasejournal.com/features/mssql/article.php/3489111/Formatted-emails-from-SQL-Server.htm

    I Hope To Use Full..
    And Choice The Best Answers

    php-wordpress Developer
    you can any problem to php wordpress to contact me
    jivanibhai7306@gmail.com
    Thanks!!...


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.