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!
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.