Db Space

How do you check db space and what are the measures available to increase the db space?

Showing Answers 1 - 2 of 2 Answers

nagaraju_p
Profile Answers by nagaraju_p

Sep 9th, 2009

sp_helpdb gives information about memory used and available.

sp_spaceused - gives space used..

subind123
Profile Answers by subind123

Mar 4th, 2011

Measure available to increase the DB space:
1) Drop objects which are no longer used.
2) Run alter database command to increase database size.