New Server - SQL move - Errors..

 

We have been on a shared server with a 200mb SQL limit but with over 1.4 million hits a month and constant 'Service Unavailable' we decided to upgrade to our own server.

 

The new server has MSDE installed and I have set up a new WWF database.    It works fine.

 

When I move all the modded pages over and use the new blank database - it all works fine.

 

When I Restore the database from a backup from the old SQL server I get errors.  Now, I have gone through the whole database and reset object owners etc and now the forums will read the data okay, but will not allow me to write to the database.   This is wierd because certain things I can do - like delete PM's but not batch delete posts.  I cannot send a PM or post to a topic or thread. 

The error I am getting is

 

Microsoft OLE DB Provider for SQL Server error '80004005'

Invalid object name 'db86488568.dbo86488568.tblTopic'.

/forum/post_message.asp, line 630

The wierd part is that nowhere does the code fully qualify the tables and fields, and nowhere in the SQL tables does it reference the 'db86488568' database or owner (This was the DB name and username of the old SQL DB)

If only seems to cause errors when the ASP uses the WITH and .Addnew  code.

 

I would be eternally grateful (so will the 3000 SOC members) if anyone can help in any way shape or form). 

 

Thanks in advance