Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Unanswered: Need help on Email setup

    I can't use the SQL Server Mail but I heard if I have an exchange server with SMTP I can still use SQL Server Stored Procs to send emails . can someone please explain or direct me to it

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Use appropriate account for sql agent to get access to mail system and then:

    BOL:

    How to set up SQL Mail (Enterprise Manager)
    To set up SQL Mail

    Expand a server group, and then expand a server.


    Expand Support Services, right-click SQL Mail, and then click Properties.


    In the Profile name list, type or select the mail profile that you configured for SQL Mail.


    Click Test to check the ability of the system to start and stop mail client services with the profile entered.
    You should receive a message that SQL Mail has started successfully and stopped a mail session with this profile.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How cool is this...

    I can send Emails to Lotus Notes Accounts from the mainframe...

    But can't from sql server...even the prod dba shop can't they can page and net send, but that's it...

    painful...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Question Snail

    Snail

    We don't have mail client installed on the SQL Server . Is there any other way emails could be sent .. someone mentioned using

    sp_OASetProperty stored proc but I have no F^&* clue what that is .. Like brian said , Mainframe can send Shit all over the place SQL Can't

  5. #5
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: Snail

    Originally posted by aashu
    Snail

    We don't have mail client installed on the SQL Server . Is there any other way emails could be sent .. someone mentioned using

    sp_OASetProperty stored proc but I have no F^&* clue what that is .. Like brian said , Mainframe can send Shit all over the place SQL Can't
    http://support.microsoft.com/default...b;en-us;312839

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •