Re: How to Compute Actual Space Used In Datafiles

From: WangKhar (Wangkhar_at_yahoo.com)
Date: 05/06/04 

Date: 6 May 2004 01:59:04 -0700

Have you looked at sp_spaceused ?

"Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message news:<u#PQovwMEHA.3944@tk2msftngp13.phx.gbl>...
> Undocumented DBCC command 'DBCC SHOWFILESTATS' is what drives that display.
> You can build some really good stuff around that command.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
>
>
> "Jack Snow" <mrbrew5510@hotmail.com> wrote in message
> news:HAemc.146252$Gd3.35432608@news4.srv.hcvlny.cv.net...
> > Has anyone discovered the algorithm and the appropriate system
> > tables/columns to use to compute the actual amount of space used/remaining
> > within a database datafile?
> > I'm trying to hit out to the values displayed in the "Taskpad" view in
> > Enterprise Manager and want to write a routine around those values.
> >
> >

Relevant Pages
Loading