Backing up a database from MS SQL 2000 server

My client is changing hosting providers. We are trying to download a full backup of our MS SQL 2000 database from the old host. We can get all of the data using the Data transfer wizard in Enterprise manager. We can get all data and structure using the Data Transfer wizard with other options. However, when we do this, all of our tables get renamed with a prefix that is our username from the old host.

So, if we have a table named customers and our MSSQL login on the old host is userA, then our table gets renamed to tableA.customers.

This won't work with our applications and stored procedures. Changing tens of thousands of lines of code is not acceptable.

Does anyone know a way we can get a full copy of the database (rules, data, structure, keys, identies, etc) without having the username prefix?

Thanks for the help!

-DAGTAI believe I have found a solution. For future reference: http://support.microsoft.com/kb/275312