Using TFDEventAlerter with MSSQL server

[EugeneK 10]

Hi

 

Does anyone have experience using TFDEventAlerter with MSSQL server? I'm trying to get notified when new records were added to certain table, pretty much copying logic from sample application, except using my own Queue and Service.

Problem is that it works for some time then randomly stops, or sometimes does not even start working when application starts.

Any suggestions how to track down this issue?

[Dmitry Arefiev 99]

Did you read and fully follow to the comment at:

<demos>\Object Pascal\Database\FireDAC\Samples\DBMS Specific\MSSQL\QueryNotify\Unit1.pas

 

Most of these are SQL Server "limitations" / "requirements".