Hi John Bailey,
Sitefinity fully supports SQL Server 2000. There is no problem to set up a project to work with it, if you do it in the beginning. As you know, when you create a project, Sitefinity asks you for the type of DB server you will use. What is problematic is to migrate the DB from SQL 2005 to SQL 2000, once already created
. SQL Server 2005 itself does not support downgrading databases to SQL 2000. This is a really problematic issue and I have had problems with it in the past, even when using SQL 2000 compatibility mode. The only solution I have found is to generate a script in SQL 2005, modify it manually and execute it against the SQL 2000 DB. This has to be done both for creating the DB schema and inserting the already existing data. It is basically a trial and error game, unless you know what parts of the script would not work for 2000.
If you have migrated databases from 2005 compatibility mode to 2000 in the past with no problems, then you might succeed with this. Just try it on a new project, created for 2005. There is a way to do it with DTS packages, which I haven't tried. Just search for it in Google.
My advice is to use the same DB server on your development machine and production server. You will avoid much hassle and save a lot of time. I also do not see a single reason not to do it. There is even a free version of SQL 2000 called MSDE, which is analogous to SQL 2005 Express.
the Telerik team