-1

I'm using Delphi 10.3 and Advantage DataBase. Here, I have used sp_SignalEvent method and then, used the TADSEvent which get triggered for all the ADS connected application and handled the operation based on the requests.

Is there any similar operation is present in SQL Server.?

Work 2 Enjoy - Enjoy 2 Work
  • 351
  • 7
  • 26

1 Answers1

1

SQL Server has Query Notifications:

Built upon the Service Broker infrastructure, query notifications allow applications to be notified when data has changed. This feature is particularly useful for applications that provide a cache of information from a database, such as a Web application, and need to be notified when the source data is changed.

Mitch Wheat
  • 295,962
  • 43
  • 465
  • 541