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 Engineer

Steve is an experienced software architect and trainer, focusing currently on ASP.NET Core and Domain-Driven Design.


Ardalis

Copyright Ā© 2020