Hello,
I had a server crash on my old SQL2000 server. I was recover the database files and I attached them in a new SQL 2005 server. But I got only one problem. Most tables were created by me and have dbo. as schema name. A few tables where created by a user that din't have dbo rights. So it has another schema.
Now by migrating it I got orphaned users, so I can't use ALTER SCHEMA. I tried to change the object owner with sp_changeobjectowner. I get Object 'XXX' does not exist or is not a valid object for this operation. Is it enough to change the user with sp_change_users_login. The solution is in that direction I think, but I'm certainly not an SQL Expert, so I hope to find some help over here...
So my main question; How can I change the schema of a few tables XXX.tablename to dbo.tablename so they become usable in my web application again?
Thanks in advance.
K.
Start Free Trial
