Post reply

Need script to calc all DB Sizes on a SQL Server

  • May 26, 2006 at 9:48 am

    #153004

    Does anyone have a script which will calculate ALL DB sizes (preferrably Allocated & Utilized) for a single SQL Server 2000 server?

    thx in advance -

    BT

  • May 26, 2006 at 11:01 am

    #640398

    Try the following script.

    sp_msforeachdb 'use ? execute sp_spaceused'

    Thanks,

    SR

     

     

    Thanks,
    SR

  • May 26, 2006 at 11:29 am

    #640409

    thx --exactly what I was looking for!

    BT

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

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