Getting SqlDependency to work takes an enormous amount of orchestration up front – especially with regards to SQL Server permissions. Steve ran into a problem which made SqlDependecy work only intermittently. He finally got to the bottom of it (was related to the dbo owner) and has blogged about it here.

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