You are here: Re: Databases in SQL Server « MsSQL Server « IT news, forums, messages
Re: Databases in SQL Server

Posted by David on 11/05/06 11:14

Just had a look I believe we currently have the Standard Edition, so i
guess then we can just buy additional CALS, for the 8 or so extra
users.

Thanks

David Portas wrote:
> David wrote:
> > Hi,
> >
> > We are about to move to SQL Server 2000, as we already have a licenced
> > copy of it. However, as i understand it you licence by the number of
> > users (where else can i find out what the options are with it). The big
> > question is: We want it to run two seperate databases, we dont want the
> > admin of one to be able to have admin of the other, or be able to use
> > the other database. Is this possible, if so where might I be able to
> > find out more about it.
> >
> > Thanks in advance for any help
> >
> > David
>
> Licensing per user is one option but not the only one and not
> necessarily the most cost-effective. Details at:
> http://www.microsoft.com/sql/howtobuy/default.mspx
>
> It is quite normal for users to have different sets of permissions in
> different databases. Depending on exactly what admin tasks you want the
> administators to take on it may make sense also to have two separate
> server instances (on the same machine).
>
> Is there some special reason why you are moving to SQL Server 2000
> instead of 2005?
>
> --
> David Portas, SQL Server MVP
>
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
>
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --

 

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

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