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 Development (2000)
 Finding out database size

Author  Topic 

Bex
Aged Yak Warrior

580 Posts

Posted - 2005-01-13 : 10:32:19
Is there a standard command to return a database's size (inclu. transaction logs and indexes)? And a command to return individual table size (in MB not row count)???????

Thanks in advance

Hearty head pats

X002548
Not Just a Number

15586 Posts

Posted - 2005-01-13 : 11:12:41
sp_spaceused


Brett

8-)
Go to Top of Page

Bex
Aged Yak Warrior

580 Posts

Posted - 2005-01-13 : 11:31:33
Thanks Brett!

Stored procedures are on my list of 'things to investigate', but I have not yet got that far!!! DOH!

Hearty head pats
Go to Top of Page
   

- Advertisement -