Mike Johnson (mj******@rsimail.com) writes:
Is there any way to set up a User in SQL Server so they DO NOT have to
qualify a table name with the owner name in a Select statement?
Depends. If the tables are owned by dbo, and the users do not own
tables themselves, there is no need to specify the username.
However, Microsoft recommends using two-part names as best practice. At
least for loose SELECT statement there is a performance gain to
specify "dbo.", since SQL Server does not have to look for tables owned
by the users themselves.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp