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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-06 : 17:26:41
|
Espen writes "I have tried for some time now to write a script (preferably asp) that does somehow, get to share with me, the size of my isp sql-servers tables. I pay by MB so it would be nice to at all times be possible to see how big my db is. I tried with ADOX, but it seems that it doesn't include any size-properties. Another idea I came up with, was to return all the data from each field in each table, and thus count all the characters, and calculate used bytes from the result. This can't possibly be a smart solution (those really big db's would really cause some trouble there yes...) or a correct reflection of the actual size.
Hope you can help me out here! Thanks alot in advance.
Server SW:
SQL Server 7.0 SP?
NT 4.0
Regards,
Espen, Norway" |
|
|
|
|
|
Getting the size of the tables in a catalog