InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 21 Apr 2026 09:03:13 GMT20http://forum.strataframe.net/FindPost31222.aspxHi,<br/><br/>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.<br/><br/>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). <br/>I suspect I must use sys.dm_qn_subscription, but how, from where? :unsure:<br/><br/>Thanks in advanceTue, 15 May 2012 08:18:45 GMTMichel Levy