w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
SqlDependency is not working event if queues are present and query is valid

Read The Mysterious Notification, Troubleshooting Query Notifications Troubleshooting Dialogs and Using SQL Trace to Troubleshoot Query Notifications for troubleshooting tips.

Run this to ensure the executes as sandbox context does not run into orphaned dbo sid issues:

ALTER AUTHORIZATION ON database::[<yourdbname>] TO [sa];

© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.