When I run:
select * from testtable
I get this error message:
Invalid object name 'testtable'.
However, if I run:
select * from testuser.testtable
It works. I'm logged in as testuser, and testuser is the database
object owner and tableowner. This was a restored database from a
different server in SQL Server 2000. The testuser login was in the
previous database. I created the same login in this new test database
and made it database owner.
I've also tried running: sp_change_users_login 'Update_One',
'testuser', 'testuser'
It completed successfully but I still get:
select * from testtable
Invalid object name 'testtable'.
I've also tried creating a different user and making it database owner
and when I change table object owner to this new user, I still get the
same problem. I need to specify:
select * from newtestuser.testtable
Even though I'm logged in as newtestuser.
I also then tried changing table owner to dbo. This seems to work
logged in as either user, but I want to have the tables owned by the
user not dbo. How can I resolve this?
Any help would be appreciated.
Erin