sql server 2008 is not supported for coldfusion8, but will it work?

We need to upgrade from sql server 2000 to 2008, but for now we don't have the resources to upgrade the cold fusion8.

Will coldfusion8 works with sql server 2008 even though it's not supported?