Is there a way to get the PUB database and make it work in SQL 2005 Express. I can copy database from SQL 2000 at work. I don't know how to get it to work with SQL 2005 Express.

Thanks,
Derrell

Typically, you need only attach the database files to the SQL Server instance you want to run it on. There's no need to import it or back it up. Just detach from the source, copy the MDF and LDF files, reattach the source, then take the files to the destination and attach there.

-Peter
peterlanoie.blog