You didn't mention what database version you're using.

If using SQL Server 2000, you can use the Data import/export wizard to copy all objects and data.

If using SQL Server 2005 (which it sounds like), you can also use the Management Studio to script the entire database contents into a file, which can be executed on the target database to create all objects and data.