Database Limititations

Is there a maximum number of databases, tables, columns
for SQL 2000? I have found much info on max RAM, but
nothing on these 3 characteristics, i.e. databases,
tables, columns.
http://www.aspfaq.com/2345
http://www.aspfaq.com/
(Reverse address to reply.)
"Charlie Johnson" <charlie.johnson@.ahlcorp.com> wrote in message
news:1715901c448b2$cbd24470$a301280a@.phx.gbl...
> Is there a maximum number of databases, tables, columns
> for SQL 2000? I have found much info on max RAM, but
> nothing on these 3 characteristics, i.e. databases,
> tables, columns.
|||Maximum number of databases: 32,767
Maximum number of objects in a databases: 2,147,483,647 (see here for more
information on this
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp)
Not sure about the number of columns, but since a row size can only be 8 K
you will more than likely max out on row size prior to maxing out on the
number of columns.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Charlie Johnson" <charlie.johnson@.ahlcorp.com> wrote in message
news:1715901c448b2$cbd24470$a301280a@.phx.gbl...
> Is there a maximum number of databases, tables, columns
> for SQL 2000? I have found much info on max RAM, but
> nothing on these 3 characteristics, i.e. databases,
> tables, columns.
|||Just ran a test of creating a table with lots of columns and got this
message:
CREATE TABLE failed because column 'c1025' in table 'test' exceeds the
maximum of 1024 columns.
So it looks like 1024 is the limit on the number of columns.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
news:eeKW9ULSEHA.1208@.TK2MSFTNGP09.phx.gbl...
> Maximum number of databases: 32,767
> Maximum number of objects in a databases: 2,147,483,647 (see here for more
> information on this
>
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp)
> Not sure about the number of columns, but since a row size can only be 8 K
> you will more than likely max out on row size prior to maxing out on the
> number of columns.
>
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Charlie Johnson" <charlie.johnson@.ahlcorp.com> wrote in message
> news:1715901c448b2$cbd24470$a301280a@.phx.gbl...
>
|||Maximum Capacity Specifications:
http://msdn.microsoft.com/library/de.../en-us/archite
c/8_ar_ts_8dbn.asp
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!