Results 1 to 3 of 3

Thread: DBs, sizes etc

  1. #1
    Join Date
    Feb 2004
    Posts
    492

    Unanswered: DBs, sizes etc

    Anyone here with a ready to go sqlscript that lists all db's, files, sizes, owner etc? I guess it's a combination of sp_databases, sp_helpdb and sp_helpdb [db].

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    There are scripts out there that will do this for you.

    Be aware of how they report db sizings etc.

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    www.sqlservercentral.com has all kinds of them. Registration is free. You can go to the scripts area and download to your heart's content.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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