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?
How do i resolve this?
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
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
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
ASKER
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?
in the new database, all tables have a prefix of the username (i guess)
how do i change it back to dbo?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are the source database and the target database of the same version?