Jon Galloway delights with a meaty post outlining a method for creating a SQL Server database cache dependency without the use of triggers. It’s an interesting read and worth looking into.