Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    139

    Unanswered: database properties query

    I've been asked to provide some information about databases on an sql server.

    I can use the following query to provide the names of all the databases:

    select * from master.dbo.sysdatabases

    What I'm also looking to provide is the current "size" of the database. I'm trying to find a table that I can link to that would provide the database size. I can manually find this number by right clicking on the database from enterprise manager, selecting "properties" and picking it up from the general tab.

    This is sql server 2K...

    Thanks.
    Thanks,
    Bill

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    look at sysfiles for each database ... that should get you started

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    may be overkill, but check out the app in my sig.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •