Posted by Erland Sommarskog on 10/01/98 11:42

(avinashraj@gmail.com) writes:
> This is a solution that we need to port to DB2 on iseries aswell, and
> now we are thinking of actually having just one database having many
> schemas within it. One schema would hold the user information and we
> are thinking of dynamically creating versions by creating additional
> schemas on the single database. This would be somethng that the
> applicaton would manage.

Beware that in SQL 2000, schema is always tied to a user or a role. Since
you need to support SQL 2000, you could get some problems there, although
you probably can come around it by creating dummy roles and use these
as schemas.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]