In response to my previous post, I have just spotted the new "Publish to Provider" option in VS2008 server explorer. It builds a script to recreate the db together with the data, and has an option to target 2000 – pretty easy solution all round...

Cheers
Ian
Technorati Tags:
SQL 2005,
SQL 2000