Post reply

How to send email using SQL Server 2005

  • August 22, 2009 at 1:03 am

    #209808

    Hello,

    I want to generate daily and weekly reports using SQL Server 2005. The reports should be generated automatically on the scheduled time and should be emailed automatically.

    Please tell me how to generate report automatically.

    Also please tell me how to make email functionality in SQL Server 2005.

    Please tell me how to do this.

    Thanks.

  • August 22, 2009 at 1:33 am

    #1043233

    Check out "DB Mail" or "Database Mail" in BOL. It is a much faster, safe and more robust replacement for SQL Mail and uses SMTP so that you do not even have to install Outlook on your SQL Server box.

    You can also do it from SQL Agent alerting (very limited and also uses DB Mail) or from a BIDS project.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 2 posts - 1 through 2 (of 2 total)

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