Multiple databases in one question without a data warehouse- YES YOU CAN!

Appears as a single database. Number of tables depends upon how many you add and the security in place.
No problems so far.