>Hi all,
>
>Can someone please tell me the pro&cons of using one Database and all tables belonging to this Database against spliting the tables to few Databases container?
>
>Thanks.

Pro: less coding (no need to say WHICH database), easier upkeep (everything is in one place)

Con: If you have many (100+ tables) or tables used by several apps it might make sense to split them into several databases.

Barbara