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

average download rates for SQL Server

I have a SQL Server hosted on a Win2003 server. I have a monitor on the server letting me know the average download speeds. When I do a large select from a remote connection, it looks like the download rate maxes out at around 10 kb/sec.

Is this an average download rate for a server hosting sql server?
actually it looks like the 2003 servers download (via FTP at least) is much much faster. Is there a different configuration for SQL Server that could be limiting the download? I'm really just assuming that the download is limited because when I do a very large select from a remote computer, it takes around 30 seconds, but the download rate never goes above 10 kb/sec.

|||My first impression would be to verify that some network segment is not limiting to 10 MB.|||Your transfer rates will be limited to the transfer rate of the network or the speed of the hard drives.