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/default.asp?url=/library/en-us/architec/8_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...
> 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 López." <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...
> > 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.
:-)
"Jerry Spivey" wrote:
> Carlos,
> See:
> 2000
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_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...
> > 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. :-)
"SQL" wrote:
> 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.