Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Owner has to qualify?! Expand / Collapse
Author
Message
Posted Friday, February 11, 2005 12:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 15, 2005 10:16 AM
Points: 2, Visits: 1

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




Post #161201
Posted Friday, February 11, 2005 12:43 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 23, 2013 9:22 AM
Points: 1,062, Visits: 355

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




Post #161210
Posted Tuesday, February 15, 2005 9:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 15, 2005 10:16 AM
Points: 2, Visits: 1

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




Post #161783
Posted Tuesday, February 15, 2005 4:32 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 23, 2013 9:22 AM
Points: 1,062, Visits: 355

That is how sql internal function.  It assume you are looking for dbo.table name unless you qualify it.

 

mom




Post #161899
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse