Post reply

Net Send alert

  • February 20, 2013 at 1:59 am

    #268889

    Dear Experts

    What is the net send alert error, how it works,

    Thanks lot

  • February 20, 2013 at 5:43 am

    #1589515

    Mo' precise plz!

    Greetz
    Query Shepherd

  • February 20, 2013 at 5:55 am

    #1589517

    just explanation for beginner

  • February 20, 2013 at 6:00 am

    #1589519

    It's an alert message send via net send triggered by a certain event...

    Refer to sp_add_alert in BOL for more.

    Greetz
    Query Shepherd

  • February 20, 2013 at 6:08 am

    #1589522

    send via what, mobile,pager or mail or popup message.....

    Thanks

  • February 20, 2013 at 8:01 am

    #1589573

    any idea

  • February 20, 2013 at 8:46 am

    #1589594

    It is sent using the Alerter Windows service and is received by the Messenger Windows server. The Messenger service is no longer enabled available in newer versions of Windows, and for good reason, since it's an easy way for people to send annoying popups to your machine. I would recommend against using the NET SEND-type alerting built into SQL Agent. What are you trying to do?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 20, 2013 at 9:08 am

    #1589604

    i want to make a popup message box alert because the server is not connected to the net currently

  • February 20, 2013 at 9:25 am

    #1589612

    What about an email? You do not have to be connected to the internet to send an email.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 20, 2013 at 9:33 am

    #1589615

    how this could happen

    Thanks

  • February 20, 2013 at 10:03 am

    #1589630

    SQL Server Database Mail does not actually send the email directly to a recipient, it sends it to an SMTP relay. If the database server can reach an SMTP relay, e.g. a local server running Exchange, and the Exchange server is connected to the internet then you can use Database Mail. This is a common scenario in corporate networks. Many SQL Server's I have worked on are not connected to the internet yet they can use Database Mail.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 20, 2013 at 10:16 am

    #1589642

    unfortunately there is no SMTP or Exchange server, thats why I am thinking about popup message

  • February 20, 2013 at 7:52 pm

    #1589795

    You could try to have a Mail server check out "MailEnable" have the smtp and pop connector and use it for SQL Server too and an independent outlook profile that can receive the mail.

Viewing 13 posts - 1 through 12 (of 12 total)

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