QueryNotifications, how to know who originates the modifications?

Author Message
 Posted 5/15/2012 2:18:45 AM
StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame User

Group: StrataFrame Users
Last Login: 11/7/2018 2:37:04 AM
Posts: 193, Visits: 9,066
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? Unsure

Thanks in advance


Tags:
Post #31222
Add to Twitter Add to Facebook


Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

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.