sp_spaceused on 2005

I executed sp_spaceused against every table in my database.  There were two
tables out of 30 over 1 MB -- both were under 10 MB.  However, when I right
click on the database in Management Studio, choose properties, and then view
the "Size" of 165 MB and "Space Available" of 4 MB, I'm confused.  How are
my 30 tables (plus various other light weight procedures, system tables,
etc) possibly consuming 165 MB of Space?

Suggestions?  Thanks in advance.

Mark

did you tried the option @updateusage = N'TRUE'?

exec sp_spaceused @updateusage = N'TRUE'

or run DBCC UPDATEUSAGE

"Mark" wrote:

> I executed sp_spaceused against every table in my database.  There were tw
o
> tables out of 30 over 1 MB -- both were under 10 MB.  However, when I righ
t
> click on the database in Management Studio, choose properties, and then vi
ew
> the "Size" of 165 MB and "Space Available" of 4 MB, I'm confused.  How are
> my 30 tables (plus various other light weight procedures, system tables,
> etc) possibly consuming 165 MB of Space?
>
> Suggestions?  Thanks in advance.
>
> Mark
>
>
>

use the option to update the usage or run DBCC UPDATEUSAGE and try again.

--
Andrew J. Kelly  SQL MVP


"Mark" <markfield88@nospam.nospam> wrote in message
news:ejALXjoWGHA.1564@TK2MSFTNGP03.phx.gbl...
>I executed sp_spaceused against every table in my database.  There were two
>tables out of 30 over 1 MB -- both were under 10 MB.  However, when I right
>click on the database in Management Studio, choose properties, and then
>view the "Size" of 165 MB and "Space Available" of 4 MB, I'm confused.  How
>are my 30 tables (plus various other light weight procedures, system
>tables, etc) possibly consuming 165 MB of Space?
>
> Suggestions?  Thanks in advance.
>
> Mark
>

Lest us know if DBCC UPDATEUSAGE changes this. sp_spaceused draw the informa
tion from the system
tables, and these are supposed to be accurate in 2005. Also, let us know if 
you upgraded the
database from an earlier version.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/


"Mark" <markfield88@nospam.nospam> wrote in message news:ejALXjoWGHA.1564@TK2MSFTNGP03.phx.
gbl...
>I executed sp_spaceused against every table in my database.  There were two
 tables out of 30 over 1
>MB -- both were under 10 MB.  However, when I right click on the database i
n Management Studio,
>choose properties, and then view the "Size" of 165 MB and "Space Available"
 of 4 MB, I'm confused.
>How are my 30 tables (plus various other light weight procedures, system ta
bles, etc) possibly
>consuming 165 MB of Space?
>
> Suggestions?  Thanks in advance.
>
> Mark
>