User/Login Permissions Problem

I use 1&1 to host my site, with SQL Server.

I've used their db management tool to create stored procs and tables.

I backed up the db stored at 1&1 and restored it on my home machine.

On my home machine, I can't access most of the db objects in the restored db via ASP.net, even if I login as sa. I get messages such as "Could not find stored procedure 'proc_name'".

1&1 provided me with a username and password to login into their SQL Server database, and all my objects now have that username as the owner.

The only way I can get the stored procs or tables to work is to prefix them all with the username from 1&1, e.g.:


exec <1&1username>.<proc_name>

Any advice would be most welcome.

Thanks,

B