By Michel Levy - 5/15/2012
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
|
|