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 size

Author  Topic 

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2005-05-30 : 20:06:46
How can i check space actually used by my database?

Thanks


mk_garg

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-05-30 : 20:13:07
Exec sp_helpdb


Damian
Ita erat quando hic adveni.
Go to Top of Page

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2005-05-30 : 20:23:59
Thanks

mk_garg
Go to Top of Page

vdavid70
Yak Posting Veteran

67 Posts

Posted - 2005-05-31 : 12:16:27
Also use sp_spacused
Go to Top of Page
   

- Advertisement -