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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Database Space

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-10 : 19:39:19
shabarinath writes "Sir
I am developing a portal in asp.net using sql server 7.0 as the database.I would like to determine the memory occupied by each database ,each table in that database.
Is this possible?
if so please let me know
thanking you in anticipation
shabri"

Nazim
A custom title

1408 Posts

Posted - 2002-02-11 : 01:10:33
Follow this link http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=9116
nr has written a stored procedure using sp_spaceused which i think will help you.



--------------------------------------------------------------
"Happiness is not something you experience, it's something you remember."
Go to Top of Page
   

- Advertisement -