Recently I had to check the maximum capacity of SQL server for our project.The real question was how many tables SQL server can have? After a fine search I could see that there is no maximum limit for the tables alone.It is considered as a database object and the maximum number of database objects supported is 2,147,483,647. The database objects includes tables, sps,indexes,views ,triggers etc…
I was searching for SQL server 2008 and here is the link with more details.
Of course the tables are not created by hand, it is planned to be created through code.