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.
