RE: Tables owned by non-sa

#1

Another valid reason to have every object owned by dbo is that you do not
have to fully qualify the name in where referencing the objects.

Rand
This posting is provided "as is" with no warranties and confers no rights.

#2

Yes, that's why I said having dbo own everything was the easiest. :-)

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com

"Rand Boyd [MS]" <rboyd (AT) onlinemicrosoft (DOT) com> wrote

Quote:

Another valid reason to have every object owned by dbo is that you do not
have to fully qualify the name in where referencing the objects.

Rand
This posting is provided "as is" with no warranties and confers no rights.

#3

I realize you said that it was easiest, but I just gave him a reason why it
was easiest

Rand
This posting is provided "as is" with no warranties and confers no rights.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: Tables owned by non-sa

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

RE: Tables owned by non-sa - 10-15-2003 , 09:08 PM

Re: Tables owned by non-sa - 10-16-2003 , 12:01 AM

Re: Tables owned by non-sa - 10-16-2003 , 01:14 PM