originally posted by: Ken Brubaker here
 

Eron Wright post some ideas on how to set up queries in Yukon to use, presumably, Yukon's event notification for ASP.NET cache invalidation.

Update: Here's a good summary of the supported caching/notifications in ASP.NET 2.0 for SqlServer 2000 and Yukon.