QueryNotifications, how to know who originates the modifications?


Author
Message
Michel Levy
Michel Levy
StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)
Group: StrataFrame Users
Posts: 193, Visits: 9K
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
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search