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.