Starting two listener in same app, Second one is not working about servicebrokerlistener HOT 3 OPEN

Are both table names the same?

from servicebrokerlistener.

different tables, i have tried all behaviours, insert, update etc. a surprising thing i discovered that after launching two triggers to two different tables in the same app i insist, trigger to table works good in which u make change first. second one got stuck as trigger is not working or responding. i have created a class to access ur code to make identity autoincrementable. i will post that class tomorrow. thanks for responding so quick. I appriciate.

from servicebrokerlistener.

Your code doesn't work as is. I made some adjustments and then it seems to work fine with both tables receiving updates.

Here is my revised gist for you including some test tables scripts

⚡️ SqlDependencyEx - TableListener Example ⚡️

from servicebrokerlistener.