• So all these child databases are all for the same client, and you have set of such databases per client? In that case, it certainly makes more sense.

    But the child databases are per "project" and they all have the same schema? I might be tempted to shove all data into the same tables, and then have views in the schemas for the projects if I don't want to change the client.

    Mind you, I know just as little abour your application as you have told me here, so I may be perfectly wrong.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]