Transferring MS SQL DB from one host to another (restricted permissions)

I need to migrate a MS SQL DB from one Internet Shared Hosting provider to another. I've asked for a backup to be placed in my FTP directory and have my new host attach it.

However, the database user didn't migrate well (I'm not sure of the error) and that user owns most of the stored procedures and table data.

Given that I don't have complete access to the server and that I don't have full permissions to the DB either, how would you copy the tables, SP's, and table data?

Is there a good tool or example script to help with such items?

Thanks,

Tim