Post reply

SQL SERVER NOTIFICATION SERVICES LOST AND RECONNECT INMEDIATELY - IS POSIBLE?

  • November 22, 2018 at 4:01 am

    #409330

    Hello it is possible to detect at the exact moment when the notification with the server is lost and immediately rconnect
    I have a SQL server in the cloud with N databases

    An application A connects to a one database and when change a value in a table you find out immediately through the SQL Server notifications, but I have noticed lately that there are times when windows update restarts the server machine and I must close my application and start it again so that it gets hooked on the notifications again

    Thanks in advance to everyone for your time

  • November 27, 2018 at 3:24 pm

    #2014729

    javier.navarro - Thursday, November 22, 2018 4:01 AM

    Hello it is possible to detect at the exact moment when the notification with the server is lost and immediately rconnect
    I have a SQL server in the cloud with N databases

    An application A connects to a one database and when change a value in a table you find out immediately through the SQL Server notifications, but I have noticed lately that there are times when windows update restarts the server machine and I must close my application and start it again so that it gets hooked on the notifications again

    Thanks in advance to everyone for your time

    And this is Notification Services - on SQL Server 2017? Or are these query notifications?

    Sue

  • November 27, 2018 at 10:57 pm

    #2014749

    Sue_H - Tuesday, November 27, 2018 3:24 PM

    javier.navarro - Thursday, November 22, 2018 4:01 AM

    Hello it is possible to detect at the exact moment when the notification with the server is lost and immediately rconnect
    I have a SQL server in the cloud with N databases

    An application A connects to a one database and when change a value in a table you find out immediately through the SQL Server notifications, but I have noticed lately that there are times when windows update restarts the server machine and I must close my application and start it again so that it gets hooked on the notifications again

    Thanks in advance to everyone for your time

    And this is Notification Services - on SQL Server 2017? Or are these query notifications?

    Sue

    Hi. 
    SQL

  • November 28, 2018 at 12:22 am

    #2014751

    javier.navarro - Tuesday, November 27, 2018 10:57 PM

    Hi. 
    SQL

    Hi Notification Services - on SQL Server 2017

  • November 28, 2018 at 8:08 am

    #2014801

    javier.navarro - Wednesday, November 28, 2018 12:22 AM

    Hi Notification Services - on SQL Server 2017

    Notification Services was removed in SQL Server 2008.

    Sue

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

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