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