move EVERYTHING over

In the past, I've always used the Copy Database Wizard. On SQL Server 2000, go into Enterprise Manager and it's under Action|All Tasks|Copy Database Wizard.

Note that I've only used this to move single databases, rather than a whole set. Also, I'm not sure if it copies everything, because the databases (while live, production databases) were quite basic, and so moving the tables/queries/stored procedures/etc. was good enough.

Frankly, it's been a while since I used SQL server in anger (database for a call center in Germany). I last used it for a fantasy football league (with web front end, auctions and the rest) at my previous job.
_________________________
-- roger