I am executing a stored procedure that is inserting into tblInfo. The owner of this table is AppUser and it is this user that is logging in and excuting this sp. But I get the following error:
Server: Msg 208, Level 16, State 1, Line 1Invalid object name 'tblInfo'.
I know this table exists and this setup works on all the other servers it's on but this one.
I got the same error when I ran the following in QA, again logged in as Appuser:
select * from tblInfo
insert into tblInfo (sName, dDate) values ('Bob', getdate())
unless the table is owner qualified (AppUser.tblInfo)!
Anybody have an idea?
Thanks in advance!!
because it was looking for dbo.tblinfo table. That is the problem all the time when you don't create the table with dbo.tablename. It is sometimes a hasle to clean up after user, and sometimes some process failed as a result of this extra feature.
But why is it looking for dbo.tblInfo when I am logged in as Appuser. And why is it that this sp works on ever other server i've installed on, except this one! There must be some config or something, no?
And no, I can't make dbo the owner. It is a requirement that a named owner is assigned.
That is how sql internal function. It assume you are looking for dbo.table name unless you qualify it.