Hi ,
Depends on the database, and the version of it.
for your information remember this valuable points
<pre lang="vb">SQLServer Strengths
* One instance can maintain 32,767 databases
* One database can contain 2 billion tables
* One table can support up to 1024 columns
* Single table supports unlimited data (or) unlimited rows up to hard-disk capacity</pre>