Hi,

I am currently working through the book and would like to test some of the examples etc online using my web host. My web host only supports SQL Server 2000 so i need the change the database to this from 2005. The question I have is, will the Caching functionality work correctly when hooked up to the SQL Server 2000 database? I read somewhere that there is a different set up for 2000 than 2005.

Anyone have any help for me please?

The paging code is the biggest difference and changing it would take some work. Read the book because Marco explains the difference in paging between 2000 and 2005.

I don't remember if Marco is using any advanced 2005 SQL cache dependencies, but this would be easy code to change - mostly just have to delete lines.

We had some discussion of this a couple months ago. I don't understand why people want to keep web hosting companies that don't support SQL Server 2005. It's been out over a year now. Take a look at WebHost4Life and DiscountASP.NET.

Eric

Unless you change the way that the caching is done the example code will work for you. You will have a few problems in translating SQL 2005 stored procedures to SQL 2000 stored procedures, but you with caching.