First of all, I'll admit I don't know much about SQL Server.
I made a backup of our SQL 2005 database at Network Solutions and had our new webhosting company import the backup. When I connect to the server using SQL Server Management Studio 2008, I can see that each of my tables are prefixed like this: OldDataBaseName.tblTableName. This is going to cause problems in all of my queries.
The new database is named something slightly different than the old one. That's probably why this happened in the first place.
What's the best way to resolve this problem?