Hi,

I'm playing with queryNotifications, and wonder if it would be possible to know which connection originates the modification tracked and reported in the ServerDataChanged Event.

In the backend SQL database, I may see the queue, the SP, the TimerDialog message, but I can't find any way to get the connection ID that triggered the beginning of the process (the one which create the QueryNotification Subscription).
I suspect I must use sys.dm_qn_subscription, but how, from where?

Thanks in advance