May 9, 2008 at 2:00 pm
Strange scenario: sysobjects has a record of a user table, however that table does not exist.
select * from SYSOBJECTS where name = 'table_name'
--(1 row(s) affected)
select * from dbo.table_name
--Server: Msg 208, Level 16, State 3, Line 1
--Invalid object name 'dbo.table_name'.
How did this happen?
SQL Server 2000 Enterprise Edition version 8.00.2039 (SP4)
Windows Server 2003 Enterprise Edition
May 9, 2008 at 2:35 pm
someone dropped the table or table is spelt differently or user account do not have permission on that table.
May 11, 2008 at 11:53 pm
select * from SYSOBJECTS where name = 'table_name'
--(1 row(s) affected)
select * from dbo.table_name
--Server: Msg 208, Level 16, State 3, Line 1
--Invalid object name 'dbo.table_name'.
After all maybe the table is not owned by "DBO" Please check :). THat happened to me long time ago, made my head ache later to found out it is owned by another user....
"-=Still Learning=-"
Lester Policarpio
May 12, 2008 at 1:01 am
Duplicate post:
http://www.sqlservercentral.com/Forums/Topic498211-146-1.aspx
Please don't cross post. It just wastes people's time answering questions that hav already been answered elsewhere.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply