How many databases can i have in sql server 2000?

Hi, my name's Carlos and i have a question...
I need to know if there is a limit in the number of databases that i an have
in sql server 2000 and if there is a difference in sql server 2005.
Thanks.
Carlos,
See:
2000
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
2005
Same I believe.
HTH
Jerry
"Carlos Lpez." <CarlosLpez@.discussions.microsoft.com> wrote in message
news:E789E737-642C-4E63-B65F-03BF02806662@.microsoft.com...
> Hi, my name's Carlos and i have a question...
> I need to know if there is a limit in the number of databases that i an
> have
> in sql server 2000 and if there is a difference in sql server 2005.
> Thanks.
|||32767 DB's per instance
http://sqlservercode.blogspot.com/
"Carlos López." wrote:

> Hi, my name's Carlos and i have a question...
> I need to know if there is a limit in the number of databases that i an have
> in sql server 2000 and if there is a difference in sql server 2005.
> Thanks.
|||Hi,
SQL 2000 :- 32767 Databases per SQL Server Instance.
SQL 2005:- 32767 databases per instance.
Thanks
Hari
SQL Server MVP
"Carlos Lpez." <CarlosLpez@.discussions.microsoft.com> wrote in message
news:E789E737-642C-4E63-B65F-03BF02806662@.microsoft.com...
> Hi, my name's Carlos and i have a question...
> I need to know if there is a limit in the number of databases that i an
> have
> in sql server 2000 and if there is a difference in sql server 2005.
> Thanks.
|||Thaks a lot.
Your help was very fast & exactly.
Thnks.
"Hari Prasad" wrote:

> Hi,
> SQL 2000 :- 32767 Databases per SQL Server Instance.
> SQL 2005:- 32767 databases per instance.
> Thanks
> Hari
> SQL Server MVP
> "Carlos López." <CarlosLpez@.discussions.microsoft.com> wrote in message
> news:E789E737-642C-4E63-B65F-03BF02806662@.microsoft.com...
>
>
|||Thaks a lot.
Your help was very fast & exactly.
:-)
"Jerry Spivey" wrote:

> Carlos,
> See:
> 2000
> http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
> 2005
> Same I believe.
> HTH
> Jerry
> "Carlos López." <CarlosLpez@.discussions.microsoft.com> wrote in message
> news:E789E737-642C-4E63-B65F-03BF02806662@.microsoft.com...
>
>
|||Thaks a lot.
Your help was very fast. :-)
"SQL" wrote:
[vbcol=seagreen]
> 32767 DB's per instance
> http://sqlservercode.blogspot.com/
>
> "Carlos López." wrote: