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: www.acehaid.org

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