General discussion


# of objects in SQL 2000 database

By les ·
We have been asked if SQL 2000 will be able to handle the 17 indexes on 84 million rows. I have checked the various reference materials about the maximums of a database and have found limits of Objects in database - 2,147,483,647. However, I cannot find out how to query the database to determine the current number of objects used. Anyone know what is the simple SQL command to do this? What else should I be concerned about in reference to maximum sizes besides disk space?
Thanks for your input.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by -oj In reply to # of objects in SQL 2000 ...

please search sql book online for "maximum capacity specifications". the info you want should be there.

Collapse -

Use the following query to determine # o

by rwblaas In reply to # of objects in SQL 2000 ...

Use the following query to determine the number of objects in your DB.

select count(*)
from sysobjects
where xtype='U'

xtype denotes the type of object you wish information on. In this cas U represents user defined tables. Check BOL for other types and sysindexes to check indexes on objects.

Be carefull using queries that rely directly on system tables. If MS decides to change these tables in future your query may not work correctly anymore.

Related Discussions

Related Forums