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

Posted on 2009-02-18
Last Modified: 2012-08-13
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!
Question by:damijim
    LVL 31

    Accepted Solution

    LVL 1

    Author Closing Comment

    Thanks much!

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now