Post reply

Script for Sizes

  • January 11, 2011 at 8:27 am

    #146747

    Is there any script out there which will give infromation about DataSize and IndexSize of each database in the server.A simple list like this

    DBName,DataSize,IndexSize,TotalSize.

  • January 11, 2011 at 9:03 am

    #1271929

    There is a stored procedure sp_spaceused that will return your info on a particular db, I believe you can pass a command into sp_msforeachdb, that might do what yopu want, but being undocumented I wouldnt risk on a production box!!

    'Only he who wanders finds new paths'

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

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