Using SQL Mail on SQL 2000

  • Hi

    First of all I hope that Yucon has a better system !

    Our SQL Mail profile should be ok. But when we want to send :

    Hi

    Have a

    EXEC master..xp_startmail

    EXEC master..xp_sendmail

    @recipients = 'jv@elecenter.be',

    @message = 'test',

    @subject = 'Order van een blocked dealer'

    EXEC master..xp_stopmail

    it doesn't work. Anybody has any idea ???

    Kind regards

    El Jefe


    JV

  • Do you get an error message?


    Kindest Regards,

  • you might need a "go" between startmail and sendmail.

     

  • Steve

    No sorry, it doesn't work

     

    Jeff

     


    JV

  • There are a lot more then just start mail for sending mail.  Are you using Exchanging Server or POP3?

    Here is one article that you might find interesting.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;153159

    BTW, you don't usally start and stop mail for just sending email.

    Also if you are using cluster server, then you have to install OUTLOOK first to make it work.

Viewing 5 posts - 1 through 4 (of 4 total)

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