Post reply

Database information in sql 7.0 not in sql 2000?

  • August 5, 2004 at 7:59 am

    #86213

    Hi,

    I have upgraded my sql server from SQL 7 to SQL 2000. One thing useful in SQL 7 was the database information which is showed when we click on the databse name in the management console.

    I've been searching for this in SQL 2000 and haven't found it yet. It looks like this information is no more available.

    I want to know the space used by table and indexes. Is there a way to do that in sql 2000 management console?

    Thanks,

    Stephane

  • August 5, 2004 at 8:33 am

    #517848

    Right click on the database name, select view, select taskpad.  You will now see the space allocated and space used for the database and log files.  If you then click on Tables in the top of the pane, you can see space reported for tables and indexes.

    Steve

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply