InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 02:12:18 GMT20http://www.sqlservercentral.com/Forums/Topic1038190-146-1.aspxthank's for the updatethe application are isolated to each othere and they use maximum simillarer tabel and SPbut fee differnet tables also .Thu, 23 Dec 2010 05:21:19 GMTNarendra-587652http://www.sqlservercentral.com/Forums/Topic1038190-146-1.aspxBefore you put different applications within a single database, I'd check to see just how much cross-dependencies there are between the apps. Do they share tables & procedures? If so, you have a case for putting them into a common database. If they share nothing, or little, I'd keep them seperated because by putting them into a common database, you're going to tightly couple these apps and make it very difficult to develop them indepdent of each other.Wed, 22 Dec 2010 07:06:03 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1038190-146-1.aspxsounds like Oracle speak to me...in SQL a database is what Oracle calls schema.in SQL an instance is what Oracle calls a database.so, to answer your question, each app should have there own 'database'i only give apps their own instance IF they need to have access to the system databases. Ie master, msdb.... or if the app needs to be controlled from a resource perspective.Wed, 22 Dec 2010 06:38:43 GMTGeoff Ahttp://www.sqlservercentral.com/Forums/Topic1038190-146-1.aspxWe have three application in sql 2005 and we want to merge the data basewould like to know what is the advantage and disadvantage of 1) Have a separate database for all application Or 2) Have 1 database for all application with separate schemas.Wed, 22 Dec 2010 05:11:18 GMTNarendra-587652