Invalid database object name

Invalid object name ' tablename ' problem here may be someone encountering an invalid object name ' tablename '. The system table does not produce this problem, and the user table has to add the user name, and then is to indicate access, such as SELECT * from author, will say the object name author invalid, and with the select * from Test.author can be accessed, this is the user's preferred identity problem.

Method One: The solution is very simple, is to see whether the test login user has DBA authority or system Management permissions, some words to remove the line. Because if the user has DBA status, the default table space after its landing is the system tablespace of the DBO, so after it is removed, the data table is accessed in the normal test table space.

Method Two: Set all test tables to dbo for OK

Execute statement: EXEC sp_msforeachtable ' sp_changeobjectowner '? ', ' dbo '

Original: http://blog.csdn.net/yfm10/article/details/4285530

Invalid database object name