Why don't you use DTS to move them over?
You want all the tables? So what's the problem with restoring the
backup and dropping all procs and UDF's
------------------------------------------------------------------------------------------
"I sense many useless updates in you... Useless updates lead to
defragmentation...  Defragmentation leads to downtime...Downtime leads
to suffering..Defragmentation is the path to the darkside.. DBCC
INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with
you" -- http://sqlservercode.blogspot.com/

I agree with SQL on this one.  If the backup is mounted you can simply use
dts to copy the tables.  If you just have the backup file then do a restore,
but make sure you change the restore options and name the database something
different (like 'backup').  Then use DTS to copy the tables from the backup
database to the production database.