table names changed in resotre

I took a sql database backup from my older website and restored it on the new one. Strangely all the tables got prefixed with a name and now all my queries/views/stored procedures are not working.

How do i resolve this?
RTKHOTAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
teebonProduct ManagerCommented:
What was the prefix?
Are the source database and the target database of the same version?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I presume what you see is that the "dbo/sa" account from the master server is not the default owner of the db.
make sure the login you use to perform the restore does have db_owner permissions in the database, that should solve the problem of the default "dbo" prefix
0
 
RTKHOTAuthor Commented:
the original prefix was dbo (it was an older sql version)

in the new database, all tables have a prefix of the username (i guess)

how do i change it back to dbo?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.