Re: The importance of fully qualifying database objects in Queries, Functions etc.

No, the system won't start throwing out errors and will use the objects with
the nearest ownership to your users (but that doesn't mean that your users
will get exactly what they want (or think they want). BOL have all the
details about the name resolution procedure.

However, with or without « dbo. », I can tell you with certainty that your
database will become a mess if you let your users creating their own views
and procedures.

Finally, for a topic like this, you should ask your question to a SQL-Server
newsgroup; if you want to have very appropriate answers.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC


"Patrick Wolf" <ppjwolf@xxxxxxxxxxx> wrote in message
news:O8xnXq4UFHA.2124@xxxxxxxxxxxxxxxxxxxxxxx
> Thank you very much Sylvain.
>
> What would happen if I just use table instead of dbo.table and user start
> creating their own views and procedures? Would it become a mess because
> the database would give an error saying that objects names have become
> ambigous? Because the object exists twice just with different user names?
>
> Thanks
> Patrick
>


.

Relevant Pages