Old Databases and Sql Query Notifications (cache invalidation)

Date Published: 07 September 2005

Old Databases and Sql Query Notifications (cache invalidation)

Julie and I were having issues with getting Sql Query Notifications to work for ASP.NET cache dependencies (for our DevConnections talks). The trick was this:

sp_dbcmptlevel yourdatabasename,90

Julie did most of the research on this one, with help from Sushil Chordia and Leonid Tsybert from Microsoft. She has more on her blog, but Iā€™m noting here so I might remember this next time.

Steve Smith

About Ardalis

Software Architect

Steve is an experienced software architect and trainer, focusing on code quality and Domain-Driven Design with .NET.


Ardalis

Copyright Ā© 2021