I was looking for query notification to get notified on multiple client for a specific table changes. It seems that this feature has been removed in SQL Server 2008 R2. Documentation is not very clear about that.

When exactly has this been removed (which version exactly)?

Is there any other way to manage that without additional components?

  • Can you define "additional components"? I can think of other options to accomplish the same task, but they are other features in SQL Server. Jun 29, 2018 at 15:42
  • I was thinking of things like trigger based solutions like that
    – chrisdot
    Jul 19, 2018 at 12:14

1 Answer 1


Query Notifications have not been removed or changed. The Documentation has just not all been ported to learn.microsoft.com.

See, eg:

Working with Query Notifications

Query Notifications - sys.dm_qn_subscriptions

Detecting Changes with SqlDependency

  • Thanks, but I was basing my assumption on that page where it says in the header "This content has been retired..."
    – chrisdot
    Jul 19, 2018 at 12:11
  • "This content has been retired..." just means that it's part of old documentation. It happens to still be accurate. Jul 19, 2018 at 13:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.