database and owner specification during select

[kindus]

Hi,
I got two questions now
1) I have two tables dbo.emp and myuser.emp, I login thru query analyzer using my login myuser which connected user myuser in the database. Whenever I user select without ownername, it select from dbo.emp not from myuser.emp

2) How do I select from a table in a different database specifying the owner of the table?

e.g. select * from pubs..emp

it works but it selects from dbo.emp, what I want is to select from myuser.emp in pubs

Could anybody explain these ??

 

[foxdev]

what I want is to select from myuser.emp in pubs

Unless I'm missing something:

[tt]select * from pubs.myuser.emp[/tt]
Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com

 

[tlbroadbent]

If MyUser is a system administrator, then MyUser is mapped to database owner (dbo) by default. Therefore, when MyUser attempts to access a table owned by MyUser, the statement will fail. You need to explicitely name the table owner as noted by foxdev. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.