Maximum number of databases on a server

I was wondering if their is a hard limit to the number of databases that can
be attached to a SQL Server 2000 standard install.
Thanks
32,767 databases per instance of SQL Server.
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:E12B7A3A-E7A0-41BA-B74E-3A60A166D5EA@.microsoft.com...
> I was wondering if their is a hard limit to the number of databases that
can
> be attached to a SQL Server 2000 standard install.
> Thanks
|||thanks
"Hassan" wrote:

> 32,767 databases per instance of SQL Server.
> "Ken" <Ken@.discussions.microsoft.com> wrote in message
> news:E12B7A3A-E7A0-41BA-B74E-3A60A166D5EA@.microsoft.com...
> can
>
>
|||May I know how to check the number of databases installed?
I checked through the Enterprise Manager, under the databases tree, there are:
-Databases
+mySys
+master
+model
+msdb
+Northwind
+pubs
+tempdb
+Sys
Can I say there are total 8 databases ?
Thanks !
"Ken" wrote:
[vbcol=seagreen]
> thanks
> "Hassan" wrote:
|||select count(*) from master.dbo.sysdatabases
That will tell you exactly how many databases are on your SQL instance.
Although I guess the more "Microsoft approved" way would be using their
views & procs (so as to not directly query the system tables) so that would
be:
exec sp_helpdb
Cheers,
Mike
"CS" <CS@.discussions.microsoft.com> wrote in message
news:5F09FFC1-5343-46FF-B87C-B92BCD6E10A9@.microsoft.com...[vbcol=seagreen]
> May I know how to check the number of databases installed?
> I checked through the Enterprise Manager, under the databases tree, there
> are:
> -Databases
> +mySys
> +master
> +model
> +msdb
> +Northwind
> +pubs
> +tempdb
> +Sys
> Can I say there are total 8 databases ?
> Thanks !
> "Ken" wrote: