title: Multiple Client Databases using Single Schema - is that possible?
body: <p>I am new to SQL Server 2008, but having read about Schemas I have this question.</p>
  
  <p>Currently, for every new client we have, I have to manually create a new database and then import all objects (tables/views/stored procs etc) from an existing database. Now whenever there is any update from the Developers (eg. Change in Table Structure, Stored Procs etc), the changes have to be made in all the databases. I am tired of using DBComparer to fix the differences in databases.</p>
  
  <p><strong>Is it possible to have one "Master Schema" which contains all the tables/stored procedures/views?</strong> So that all "Client Databases" could refer to this "Master Schema", but still be able to maintain its own Data without any problem.</p>