Server Size

Question

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

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

SuperDBA-207096 SSCrazy Eights Points: 8176 More actions · Answer 1

I think there's a sproc out there called sp_spaceused if that's what your looking for?

Greg Larson wrote a script a while back.. uses xp_fixeddrives

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 2

[font="Verdana"]Try the below code.

SELECT sum((size*8)/1024) as 'All db Size' from sys.master_files[/font]

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 3

SSC-Dedicated

Points: 36121

July 29, 2008 at 2:37 am

Thanks Vidhya