February 11, 2005 at 12:18 pm
Hi!
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)!
WHY!
Anybody have an idea?
Thanks in advance!!
February 11, 2005 at 12:43 pm
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.
mom
February 15, 2005 at 9:47 am
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.
Thanks,
Purvi
February 15, 2005 at 4:32 pm
That is how sql internal function. It assume you are looking for dbo.table name unless you qualify it.
mom
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply