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

dips255
Starting Member

17 Posts

Posted - 2010-02-15 : 05:08:37

We have just migrated from a shared hosting to dedicated hosting environment

I got following error on my asp page.

Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'resi_sell'.

I guess its something related to database owner because when i run the query through query analyser using table name prefixed with owner name then it works

please help

Kristen
Test

22859 Posts

Posted - 2010-02-15 : 05:55:37

Application is not connecting as the correct owner-name.

You can set up an Alias for the Server Login's connection to the Database as a specific Owner name

dips255
Starting Member

17 Posts

Posted - 2010-02-16 : 06:13:58

Thanks
the issue has been resolved

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-02-16 : 21:18:47

this is a good reminder that unless EVERYTHING falls under dbo schema then you should always prefix your object references with schema. for example

select * from dbo.myTable
select * from russell.myTable
exec dips255.myStoredProc

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources