Re: newbie, querie help/advice

From: Tim Mavers (webview_at_hotmail.com)
Date: 01/26/05 

Date: Wed, 26 Jan 2005 08:51:18 -0600

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:uhNWm1vAFHA.208@TK2MSFTNGP12.phx.gbl...
> It is the owner of the object (becomes "schema" in next version). It is
> considered good practice to qualify object name with owner and can also
> improve performance.

I understand that you can have multiple objects in the same database with
different owners (why I have no idea, but I understand it is allowed). But
what is the purpose of using dbo.? For example:

user1 is the owner of mytable (user1.mytable)
user2 is the owner of mytable (use2r.mytable)
user3 has read access to both tables.

user3 executes code "select dbo.name from dbo.mytable"

What the heck happens here? It just seems very sloppy to me. I don't know
why you would want multiple tables of the same name in the same database
(even through they are owned by different users). I just seems messy.