SQL Server Performance

SQL mail

Discussion in 'Getting Started' started by california6, Apr 25, 2007.

  1. california6 New Member

    If I have to configure SQL server 2000 to send emails alerts, I had to configure an email profile on SQL Server 2000 box. Is the same case with SQL Server 2005 aswell?

    Database mail in 2005. Is it something different than the earlier versions? Appreciated if someone share some thoughts on this.

    Thanks,
    Cali
  2. MohammedU New Member

    SQL mail is deprecated in sql server 2005 which uses MAPI profile where database mail in newly introduced in 2005 which uses SMTP.

    If you want to use sql mail in 2005 it is the same as 2000 but I don't see any reason to use sql mail in 2005 when you have database mail...

    You don't need to install outlook for database mail...

    SQL Server 2005 Books Online
    Database Mail Configuration Wizard
    http://msdn2.microsoft.com/en-us/library/ms175951.aspx
    http://msdn2.microsoft.com/en-us/library/ms186358.aspx
    http://www.sqlservercentral.com/columnists/cBunch/introtodatabasemailinsql2005.asp

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. ghemant Moderator

    More over SQLMail don't fully supports on Fail Over Cluster server, it is a bug accordinghttp://support.microsoft.com/kb/298723/EN-US/

    here is a KBhttp://support.microsoft.com/kb/315886/EN-US/ on Common Problems FYI.


    Regards

    Hemantgiri S. Goswami
    MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
  4. satya Moderator

    IN SQL 2005 you can take help of Notification services which works more better than Database mail or sqlmail.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. MohammedU New Member

    I never used Notification services <img src='/community/emoticons/emotion-6.gif' alt=':(' /><br />How it is going to work with sql agent job failure notification...<br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />
  6. ghemant Moderator

  7. MohammedU New Member

    Thanks Hemant ...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  8. satya Moderator

    BOL is also your good friend here.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page