determining db size

Best way to do it is thru Task pad with Enterprise Manager.

Click the DB in Enterprise manager and click view and select task pad.



quote:Originally posted by goinggoneco

How can we (programmatically and otherwise) determine how much of our database allocation we are using?

I ran sp_helpfile ... but this reports that I am already using the 50MB (actually more) and we havn't even started yet. I assume this is pre-allocated space.

But I need to programmatically figure out how much space I am using so that I can instrument clean-ups (and purchasing more space before I hit the wall.

Any help appreciated.

David
</blockquote id="quote"></font id="quote">

B.

DiscountASP.NET
http://www.DiscountASP.NET

 

We will let our Product Manager know of your suggestion.

DiscountASP.NET
http://www.DiscountASP.NET

 

This SP would give you some idea

sp_spaceused

but it is very difficult to understand the output.


quote:Originally posted by goinggoneco

I was hoping for a "programmatic" approach such that my site can warn me when I am about to hit a hard limit.

Or ... so I can more easily view usage -- by having an indicator on my website.

Other thoughts?
</blockquote id="quote"></font id="quote">

B.

DiscountASP.NET
http://www.DiscountASP.NET