TABLE 1: Cache-Dependency Differences
SQL Server 2000/7.0	SQL Server 2005
Table-change dependencies	Result-set dependencies
Requires configuration settings	Supported through ADO.NET SqlCommand class
One-time setup of SQL Server database	No setup required
Polling model	Notification model