SqlCacheDependency in an OutputCache Directive

SqlCacheDependency in an OutputCache Directive - SQL 2000

Page was executed at 28/08/2008 04:26:57

OrderID	CustomerID	OrderDate	Freight	ShipCity
10248	VINET	27/08/2008 10:52:00	32.3800	Reims
10249	TOMSP	05/07/1996 00:00:00	11.6100	Münster
10250	HANAR	08/07/1996 00:00:00	65.8300	Rio de Janeiro

Open update window

In this page:

<%@OutputCache VaryByParam="None" Duration="30"
               SqlDependency="nwind-cache:Orders" %>

In web.config:

<system.web>
  <caching>
    <sqlCacheDependency enabled="true" pollTime="75000">
      <databases>
        <add name="nwind-cache"
             connectionStringName="nwind"
             pollTime="500" />
      </databases>
    </sqlCacheDependency>
  </caching>
</system.web>