Hi Joel,
Welcome to the MSDN newsgroup.
As for the SQL Cache dependency in ASP.NET 2.0, we need to make sure the
configuration in the following places are correct:
1. In sqlserver, we need to make sure we've enabled the sql cache through
aspnet_regsql.exe tool
2. In ASP.NET web application, ensure that web.config file contains the
correct setting for that certain sql cache database/table
If the above are all correctly configured, there may have something else
cause the problem. And for general throubleshooting, you can try the
following means also:
a.Use Sql Profiler to monitor the SQL Server database server to see whether
there're sql query operations peformed by asp.net sql cache thread...
b.Add a RemoveCallBack handler for the cached item to see whether it is
called immediately after you add the cache item.
In addition, here is the walkthrough article in MSDN on using sql cache
dependency in asp.net 2.0, you can also try testing through this to see
whether it can work:
#Walkthrough: Using ASP.NET Output Caching with SQL Server
http://msdn2.microsoft.com/en-us/lib.../e3w8402y.aspx
Hope this helps.
Regards,
Steven Cheng
Microsoft Online Support
Get Secure!
www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)