Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
nshankar
Starting Member
9 Posts |
Posted - 2007-09-19 : 05:21:51
|
HI Allhow to calculate the disk storage space of the database from the front using asp.netCan anyone give suggestionThanks |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-09-19 : 05:23:24
|
[code]EXEC sp_spaceused[/code]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
nshankar
Starting Member
9 Posts |
Posted - 2007-09-19 : 06:05:37
|
fine it works but displays the entire space occupied. if i want to check for used space... what is the default space of the database and maximum sizeThanks |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-19 : 06:07:17
|
There is no maximum size except for SQL Express. E 12°55'05.25"N 56°04'39.16" |
 |
|
nshankar
Starting Member
9 Posts |
Posted - 2007-09-19 : 06:09:56
|
Is DEfault space size is of 50MB? |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-19 : 06:18:11
|
Ask Michael Valentine Jones if he can include that piece of information in the script mentioned in the link. E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|