How the SQLDependency class is taking advantage of the SQL Service Broker feature?

Question

Since I couldn't find any decent resource to provide me with this kind of explanation or some graph, after accumulating sufficient knowledge about this topic, I decided to create one by myself and to post it as an answer this question.

Hope it will help anyone who is looking for such explanation.

score 1 · Answer 1 · edited Jun 20 '20 at 09:12

1

You will be able to see that the SQLDependency operation is divided into 2 stages:

The purpose of the first one is for deploying of all required Broker objects, including subscribing for Query Notifications
The second stage purpose is for the actual listening of new changes notifications

edited Jun 20 '20 at 09:12

Community

1
1

answered Oct 04 '17 at 14:02

Yair Nevet

12,725
14
66
108

@RemusRusanu thanks, you can use this diagram in your article if you wish. – Yair Nevet Oct 05 '17 at 07:56

How the SQLDependency class is taking advantage of the SQL Service Broker feature?

1 Answers1