This came up in a previous thread and it took a surprising amount of work. I don't remember the exact details.

If you want a subset of the data, you're probably going to have to extract what you want manually.

-Mike

>I need to copy a database of about 1 gig that is stored in SQL 2000 to MSDE (for a demo). What is the best method? Is there an easy of copying parts of some tables (last year of data for example)?