Software

Ask something
Discussion Locked

# of objects in SQL 2000 database

0 helpful
2 replies

by les

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by -oj

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

by rwblaas

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.

This discussion is closed to new replies.