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)
 freeand used space in database

Author  Topic 

oracle_corrgi
Yak Posting Veteran

98 Posts

Posted - 2006-08-23 : 00:18:11
hi

can i know how to see the freespace and used space in the database
through tsql

thanxs


database

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-23 : 01:05:59
check out DBCC commands in books online. there is a ton of them.

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2006-08-23 : 09:20:10
There's also sp_spaceused.
Go to Top of Page
   

- Advertisement -