none
notification service not working on system startup

    Question

  • Hi All,

      I am using sqlCacheDependency in my web application. My data resides on a sql server 2008 SP2 database. It works great in general, but I did notice something lately. When I first start up my machine, the First time I am doing a change to the data through my webform cache items dont lose their value. Then afterwards everthing works okay, even if I close visual studio and reopen or restart sql server services it runs well and deletes what is in cache based on data changes. The problem happens only when I restart my machine and do my first update on the database. 

    I have seen the following error in event viewer when the service broker starts:

    Cound not find remote service sqlnotificationservice because it does not exist. It happens at the time the service broker starts.

    Any help on this is appreciated.

    Saturday, February 05, 2011 11:45 PM