Invalid object name - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Invalid object name

Author

Topic

sqlstartermar
Starting Member

1 Post

Posted - 2010-02-28 : 15:04:34

Hi All,

I am new to sql server 2005.When I try to access a table,it is throwing "Invalid object name" error.I have all the permissions to my user account.I have used accessing key word dbo. also,Can any body help me in this..?
Thanks in advance

Regards
SqlLearnerMar.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-02-28 : 15:11:53

sounds like the object doesn't belong to dbo schema.

what happens if you do this:



SELECT	schema_name(schema_id), name
FROM	sys.tables
WHERE	name = 'TABLE_NAME_HERE'

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2010-02-28 : 17:33:53

What's the table name? Also, make sure you don't have a space between dbo. and the table name.

There are 10 types of people in the world, those that understand binary, and those that don't.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources