I would have to disagree there. We run multiple SQL Server instances (which consists of the memory structure, physical files and logical structure) on one server. The reason for this is multiple sort code, which is like the same as the character set in Oracle. Personally I think the developers had no good business case for a different sort-order and normally we run one instance per server with multiple databases.
Some of our applications are using Case-Sensitive Dictionary sorting while others are using case-insensitive binary. There is another whole topic about sort-orders as they can be set at Instance Level (which is the same as an Oracle instance), database level or table level. The databases on SQL server are not the same as the schema in Oracle, since the schema in Oracle is based on a user. In SQL I can have a database an multiple users within the database, all the objects in Database A are belonging to User A, User B needs to be granted rights to objects in Database A - therefore not exactly the same as a schema in Oracle. In Oracle all the objects in a schema belong to a single user and they have access to them. I have been reading the forums for a while so if any of my comments are slightly wrong please do not flame me, I am busy typing this at work :-) If they are way wrong then please let me know that's why I read this forum - to learn. Cheers Timothy Clarkson SQL DBA/OCA -----Original Message----- [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 10:05 PM To: Multiple recipients of list ORACLE-L <SNIP> > What would be the point of installing two SQL Server > "servers" on the same box? Similar to setting up 2 or more > instances on one host? No point that I can think of, I just know it can be done. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Clarkson, Timothy T SEOP-OEIRH/1 INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
