The easiest way I've found is to use the Import and Export Data Wizard that comes with SQL. It basically takes you through the steps of copying data from one DB to another. Selec the source, destination, the objects (tables, stored procedures, functions, etc.) and it does everything for you.