yes, I know if I remove "GO' I can run it well, But you have many tables to create and you make sure all your tables are created then you...

hi every body !

thank every ones to answer my question, and now i find the solution for this problems, it is using Partitioned Tables and Indexes.

it's very very simple .......

@every body:

Thanks for your answer

But my question exactly is about architecture to design database system. When you have an application like that !

How do you organizer database ?...