Posted by newtophp2000 on 03/13/06 21:31

My thanks to all who replied. So, if I understand it correctly, while
the syntax remains the same, the dbo part will really refer to a schema
within the database? (i.e., each user will have their own separate
area where they can create tables.)

(Erland, you are right. proddb01 is a server, we just name it that way
to distinguish it from test servers where we can play freely. Nothing
else runs on these servers other than the database; hence the name.)




Erland Sommarskog wrote:
> The same as you always have done.
>
> The example is a little funny. "proddb01" sounds like a database, but
> it appears in the position of the server name.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>

[Back to original message]