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...

Database Publishing Wizard

Cheers

Ian

Technorati Tags: ,