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 1
Invalid 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!!