Barry Lollo wrote:
Greg,
Practix might be a good example for you to look at then.
They use the Default Instance (1 SQL server), but they have 3 databases
that they use.
Mspdata - This stores the completed data - can get large
Msplocal - This is temporary data, such as appointments etc
- should be relatively small
Mspref - This is Data like Item Codes, Bank Details, and other Static
data. - will be small
The application uses all 3 Databases which all have a 2 gig limit giving
them the ability to address 6 gig theoretically, getting around the 2gig
restriction.
Clearer ??
Barry,
Much. Its just that no one was saying this.
I assume thenm there is some flexibility in how you could cut up an app
such as MD.
Results one database, Requests another. Letters another?
Is it flexible enough to allow the operation of primary and secondary
keys across the various databases? If so, you could reduce a 'database'
to a single table?
Thanks
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
