Nevermind all - I got it using the command line Publishing Wizard...


I have some tables in a SQLServer 2005 that I exported to a new empty SQLServer 2005 database (I need to provide tables with data to a 3rd party but only for some of the tables in the database). this worked fine. However, I just found out that the 3rd party receiving the database has SQLServer 2000, not SQLServer 2005. What is the best method (or any) of creating a new SQLServer 2000 database that contains only a selection of tables from the original SQLServer 2005 database that can be attached to SQLServer 2000?

The only thing I have come up with so far is the Database Publishing Wizard...