Very informative explanation of Beta2 SqlDependency changes and running as non-admin

There was a problem with SqlDependency pre-Beta2 which created headaches for anyone trying to use it as a non-admin. It also created headaches for programmers at Microsoft who were in charge of it. They finally reworked some of the plumbing in order to get past the permission issues. In this DataAccess blog post, Sushil Chordia not only explains why the problem existed, but what they did to fix it, how to use SqlDependency now (most changes were in the plumbing, but you do have to do some minor changes in your code) and also what permissions are necessary in SQL Server to get it working.

Don’t Forget:

  Sign up for my newsletter so you don't miss my conference & Pluralsight course announcements!  

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.