Working with SQL output Caching and SQL 2005 is a little different then working with SQL 2000. Here is a great resource on how to set this up for your ASP.NET pages.

http://msdn2.microsoft.com/en-us/library/ms379559(VS.80).aspx#caching_topic2

I could not have said it better myself ;)

Doc