Posted on 2007-10-17
Last Modified: 2012-05-05
I have installed SQL 2005 standard for a DB server. I wanted to configure sqlimal, but it is not in the management console. I have installed all components and still no imail. I installed sql 2005 enterprise on another server thinking it might be the version, but sqlimail is not there either. Am I doing something wrong or missing a step?
Question by:VNRHelp
    LVL 8

    Expert Comment

    The option to configure mail is available in Management ---->Database Mail---right click this option and you should be able to configure SQL Mail.

    Please let me know if this helps.


    Author Comment

    SQL mail and SQLimail are different. Maybe I am wrong, but there should be 2 options, Database mail and sqlimail.
    LVL 8

    Accepted Solution

    nstalling and configuring SQLiMail
    You can use the SQLiMail Configuration Wizard to install and configure SQLiMail in a database. You can initiate the wizard from the SQLiMail entry in the Management folder in Object Explorer. The wizard collects information, including the database to install to and user information to create a SQLiMail profile.

    Using SQLiMail
    After you have configured a mail profile, you can call the sendimail_sp stored procedure to send mail from SQL Server. The following example shows how to send SQLiMail using a profile named SQLServer.

    DECLARE @QueryResult int
    SET @QueryResult = (SELECT Count(*) FROM Person.Contact)
    EXECUTE sendimail_sp

    Please let me know if this helps


    Author Comment

    "SQLiMail entry in the Management folder in Object Explorer"

    This is the problem.... SQLiMail is not in the folder. I know how to use it, it is just not there.

    Author Comment

    I am gonna give you the points dude... This was my mistake.... In this book I have it says SQL mail and Imail are 2 different things.... but the book is either old or wrong...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now