TABLE 1: Cache-Dependency Differences
SQL Server 2000/7.0SQL Server 2005
Table-change dependenciesResult-set dependencies
Requires configuration settingsSupported through ADO.NET SqlCommand class
One-time setup of SQL Server databaseNo setup required
Polling modelNotification model