Overview of Sql Cache Dependency

Source Link: http://www.aspnetresources.com/blog/sql_cache_depedency_overview.aspx

....................
Configuring SQL Cache Dependency (Sql Server 7 and 2000)

There’s some manual configuration of web.config required to specify which connection string to use, how often to poll the database for changes, etc. You can set up more than one database connection and poll several databases—all from the same web application!

You also need to “enable a database for SQL cache dependency” by running Aspnet_regsql.exe. Pay attention to the -ed (enable database), -t (table) and -et (enable table) switches.