Post reply

get a column from SP_HelpDB

  • June 11, 2012 at 2:19 pm

    #262267

    Hello,

    SP_helpdb is perfect for what I need, since it has all the db names, and size of each db, the only thing i need now is the sum of all db_size which is the actual column name from sp_helpdb, if i can get the sum of that particular column, that would be great, anyone know how i can get a particular column from sp_helpdb or any other stored procedure?

    thanks

  • June 11, 2012 at 2:25 pm

    #1499510

    select DB_Name(database_id) DataBaseName,physical_name,size/128 SizeInMB,* from sys.master_files

    select Sum(size)/128 SizeInMB from sys.master_files

  • June 11, 2012 at 2:29 pm

    #1499515

    Beautiful thank you 🙂

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

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