QueryNotifications, how to know who originates the modifications?

Print Topic | Close Window

By Michel Levy - 5/15/2012 2:18:45 AM

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? Unsure

Thanks in advance

Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.