Barry Lollo wrote:
Greg,
In MS SQL server 2000 you can have up to 16 instances installed on the
one PC.
In essence, and Instance is another SQL Server.
Example:
My computer name is "SERVER", then the default instance (or SQL SERVER)
would be referred to as SERVER when configuring the connection details
in your application. Inside that SQL Instance we can have many
databases.
When one installs Pracsoft, you must have an Instance (2nd SQL Server
installation potentially....I'll qualify that later) called
"SERVER\HCNSYSTEM".
The 3rd installation of SQL server in that PC would be called
"SERVER\<instancename>" whatever you want to call it.
So when configuring your application to talk to an SQL server you would
refer to its Instance.
Each of them can be stopped and started independently as they are all
individual SQL servers.
Qualifying that statement before, one can install the 1st installation
of SQL server on a PC and call it "SERVER\HCNSYSTEM".
We can have an situation where the default Instance "Server" is SQL 7.0
We can have out 2nd Instance as SQL 2000 Service Pack 2.
We can have our 3rd Instance as SQL 2000 Service Pack 4.
I suspect, but haven't tested it yet, but our 4th Instance could
probably be SQL 2005.
Oracle and other products in the same vein have a similar strategy
available.
I hope that clears it up.
Barry,
Yes and no, its a nice internal explanation of some of the complexities
of MS SQL, and the \SERVER\HCNSYSTEM structure is familiar to me.
What I'm still not clear about is that if you have a database for MD3,
can you have more than one instance for it in order to increase the
available database capacity, say by breaking up parts of the
application's table structure into different instances?
Is this how you can get around the alleged 2 GB database limit?
The discussion related to data volume, and it seems you can have
multiple database engines addressing multiple applications
simultaneously, but that still doesn't explain how a single application
like MD3 would have its data handled.
Greg
--
Greg Twyford
Information Management & Technology Program Officer
Canterbury Division of General Practice
E-mail: [EMAIL PROTECTED]
Ph.: 02 9787 9033
Fax: 02 9787 9200
PRIVATE & CONFIDENTIAL
***********************************************************************
The information contained in this e-mail and their attached files,
including replies and forwarded copies, are confidential and intended
solely for the addressee(s) and may be legally privileged or prohibited
from disclosure and unauthorised use. If you are not the intended
recipient, any form of reproduction, dissemination, copying, disclosure,
modification, distribution and/or publication or any action taken or
omitted to be taken in reliance upon this message or its attachments is
prohibited.
All liability for viruses is excluded to the fullest extent permitted by
law.
***********************************************************************
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
