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

Posted by David Portas on 11/04/06 14:33

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

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