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

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

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!
1 Solution
James MurrellProduct SpecialistCommented:
damijimAuthor Commented:
Thanks much!

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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