473,898 Members | 3,177 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Databases in SQL Server

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

Nov 3 '06 #1
5 1584
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/m...S,SQL.90).aspx
--

Nov 4 '06 #2
Thanks for the reply. I will check the link now. The reason we are
moving to MS SQL 2000, is because we received it with a server a while
ago. However, due to time constaints it was never setup, as i only had
4 days on-site, and other things took priority.

I know we need two users for one of the databases, and may
unfortunately need 8 for the other so ill check on that now thanks.

There is another query as well, if possible. I was looking into
performance of it and obviously it depends on the structure of the
databases. We are not sure if we trust the suppliers of each database,
to make them run efficiently. Therefore apart from wrapping the SQL
servers, in Virtual Machines, and limiting the virtual machines use of
the CPU, is there any other way to control the resources used by the
server, in order to stop it using the full resources of the machine, in
case of bad structuring?

Thanks again for the reply, hope you had a good weekend

David

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/m...S,SQL.90).aspx
--
Nov 5 '06 #3
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/m...S,SQL.90).aspx
--
Nov 5 '06 #4
David wrote:
Thanks for the reply. I will check the link now. The reason we are
moving to MS SQL 2000, is because we received it with a server a while
ago. However, due to time constaints it was never setup, as i only had
4 days on-site, and other things took priority.

I know we need two users for one of the databases, and may
unfortunately need 8 for the other so ill check on that now thanks.

There is another query as well, if possible. I was looking into
performance of it and obviously it depends on the structure of the
databases. We are not sure if we trust the suppliers of each database,
to make them run efficiently. Therefore apart from wrapping the SQL
servers, in Virtual Machines, and limiting the virtual machines use of
the CPU, is there any other way to control the resources used by the
server, in order to stop it using the full resources of the machine, in
case of bad structuring?

Thanks again for the reply, hope you had a good weekend

David
You can restrict the number of processors and the number of threads
used by SQL Server. You can also limit the amount of RAM available to
it. You'll find those settings under the Properties option if you
right-click on the server in Enterprise Manager.

Unless you have other more demanding applications on the same server it
is usually better to allow SQL Server to manage those things for
itself. SQL Server works best with as much RAM as possible and it will
automatically yield resources to other processes that need them.

--
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/m...S,SQL.90).aspx
--

Nov 5 '06 #5
Yet, again thanks for the great help. We will be putting in 2.5GB RAM,
to give MS SQL server plenty of room to work. If we need to then we can
restrict it to 1 of the two hyper-threaded processors. Basically it
will be running on the same server as an AD domain controller, for 10
PC's with FileSharing, so im guessing in that case we will be fine.

Im sorry i would check but need to get them to ifnd me the CD's, when
applying the RAM and processor constraints, is this per Server
instance. Im just wondering, if this can be done at a database level.

Thanks for all your time and help, its greatly appreciated.

David
David Portas wrote:
David wrote:
Thanks for the reply. I will check the link now. The reason we are
moving to MS SQL 2000, is because we received it with a server a while
ago. However, due to time constaints it was never setup, as i only had
4 days on-site, and other things took priority.

I know we need two users for one of the databases, and may
unfortunately need 8 for the other so ill check on that now thanks.

There is another query as well, if possible. I was looking into
performance of it and obviously it depends on the structure of the
databases. We are not sure if we trust the suppliers of each database,
to make them run efficiently. Therefore apart from wrapping the SQL
servers, in Virtual Machines, and limiting the virtual machines use of
the CPU, is there any other way to control the resources used by the
server, in order to stop it using the full resources of the machine, in
case of bad structuring?

Thanks again for the reply, hope you had a good weekend

David


You can restrict the number of processors and the number of threads
used by SQL Server. You can also limit the amount of RAM available to
it. You'll find those settings under the Properties option if you
right-click on the server in Enterprise Manager.

Unless you have other more demanding applications on the same server it
is usually better to allow SQL Server to manage those things for
itself. SQL Server works best with as much RAM as possible and it will
automatically yield resources to other processes that need them.

--
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/m...S,SQL.90).aspx
--
Nov 6 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2107
by: Mark Townsend | last post by:
Following is a summary of articles spanning a 7 day period, beginning at 23 Feb 2004 05:29:19 GMT and ending at 01 Mar 2004 04:12:14 GMT. Notes ===== - A line in the body of a post is considered to be original if it does *not* match the regular expression /^\s{0,3}(?:>|:|\S+>|\+\+)/. - All text after the last cut line (/^-- $/) in the body is
0
1654
by: Cara | last post by:
LAST CALL FOR VOTES (of 2) unmoderated group comp.databases.etl Newsgroups line: comp.databases.etl Extraction, transformation, loading issues. Votes must be received by 23:59:59 UTC, 12 Dec 2003. This vote is being conducted by a neutral third party. Questions about the proposed group should be directed to the proponent.
1
3205
by: Hai-Chu Hsu | last post by:
Hi, I want to restore my databases from the old SQL Server installation into a new installation of SQL Server. My new installation of SQL Server has different data path from the old installation. In addition, the data owners of some databases in the old SQL Server installation are not dbo. I have backups for all the databases in the old installation SQL Server. Can anyone tell me how to restore my databases from the old SQL Server
2
1131
by: Kim Christensen | last post by:
After installing MS SQL Server 7 several databases appears in the database folder named: distribution, master, model, msdb, northwind, pubs and tempdb. Is it safe to delete any of those pre-installed bases? Regards Kim Christensen
0
2303
by: Cara Altman | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.databases.etl This is a formal Request For Discussion (RFD) for the creation of a world-wide unmoderated Usenet newsgroup comp.databases.etl. This is not a Call for Votes (CFV); you cannot vote at this time. Procedural details are below.
4
2467
by: mike | last post by:
Hi, I am trying to determine what the overhead is per database in SQL Server 2000 Standard. I have the option to put several customers in one database, or give each customer their own database. I would like to put each customer in their own database to simplify maintenance and strengthen security. I have found the following document which shows the memory used by various objects in SQL Server:
3
2181
by: AK | last post by:
Hi Our product uses MS-SQL Server 2000. One of our customer has 10 installations with each installation stroring data in its own database. Now the customer wants to consolidate these databases into one and we already have plan for that by consolidating one DB at a time. But first they want to find how many unique or duplicate entries they have across all the 10 databases Assumptions:
10
1899
by: Br | last post by:
We have a product that is being used by a client to outsource salary packaging. They therefore run several instances of our database, one for each of their clients. There is now a requirement to run operations globally across all the databases including a central database holding some global information. What method(s) would people recommend that would work best? (Access2000 ADP, SQL Server 2000)
3
3709
by: byrocat | last post by:
Up until now, I've been working with V& DB2 UDB databases, using Embarcadero DBArtisan as my GUI tool. I also have other tools that I use in my day-to-day job so running directly on the server via the CLP is not a viable option. I've just had a number of V8 DB2 UDB databases added to my task list. Of course #1, the old V7 DB2 ODBC client software doesn't connect to V7 databases.
1
3863
by: judy | last post by:
I have several databases that are used to collect data for different client-projects. My intention was to collect the data, and administer mySQL so each client could see only their data. Each of these databases used to collect data have the same tables. There are other databases which are available to all the users which contain common information. The command "show databases" lists all of the databases (visible to the particular...
0
9993
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
9842
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11265
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10859
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10954
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10487
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7191
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5882
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6078
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.