ASP.NET 4 Unleashed

Using Push SQL Cache Dependencies

When using Microsoft SQL Server 2008 or Microsoft SQL Server 2005, you have the option of using Push SQL cache dependencies rather than Polling SQL cache dependencies. These databases include a feature called query notifications, which uses the Microsoft SQL Server Service Broker in the background. The Service Broker can automatically send a message to an application when data changes in the database.

Warning

You can create two types of databases with SQL Server Express: a Local or a Server database. You should not use Push dependencies with a Local database. You should use Push dependencies only with a Server database.

You cannot create new Server databases when using Visual Web Developer. You can create a ...