You are here: Re: Naming syntax in 2005 « MsSQL Server « IT news, forums, messages
Re: Naming syntax in 2005

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
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация