• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

How do I find out the maximum size allocated to a MS SQL 2005 database and how much is being used?

Hello,
I have a single database in MS SQL 2005 (there are other dB's that are not mine). The database name is ProWebDev.

Can someone provide me with a SQL query that'll return <the amount of space used by a database (in MB's)>, <the maximum size of the database (in MB's)>, and <the percentage used> in decent human readable format?

I will award points to the first response that works and meets the criteria above. Thanks!
0
damijim
Asked:
damijim
1 Solution
 
James MurrellProduct SpecialistCommented:
0
 
damijimAuthor Commented:
Thanks much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now