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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.